How can we create a report with a comparison of Priority 1 cases vs Total case opened in a month over a span of 3 months and I also want to segregation of data by a custom field Dispatch and Non- Dispatch

[nag2042]

How can we create a report with a comparison of Priority 1 cases vs Total case opened in a month over a span of 3 months and I also want the segregation of data by a custom fields on Incident table for State: Dispatch and Non- Dispatch. and the details in a table as below:

[Chuck Tomasi]

Hi Nagender,

It sounds like you are looking for information provided by Performance Analytics. I invite you to open a dialog with your ServiceNow account team.

https://docs.servicenow.com/bundle/istanbul-performance-analytics-and-reporting

[nag2042]

Hi Chuck,

We want to send out the reports to different customers. Performance Analytics gives Trend analysis but we cannot segregate the the data on monthly bases as above. It shows all the data over a period of 3 months rather than monthly. The X- axis is PA dashboard doesnt show the X-Axis in months rather it shows in dates and also the data in the table.

[gyedwab]

Hi Nagender,

With Explore Analytics you can build the report as follows:

This is directly against the live data; it doesn't require you to set up and trend jobs. The only thing I did was map the "Priority" field like so:

That's a virtual column in the report, not something defined by an administrator.

If you want to try it out, there's a 30 day trial here.

Here's the same as a pivot:

You can publish that live to a Servicenow Dashboard with drill-down:

[nag2042]

I am looking to build it with in Servicenow without any external tools/Plugins support