Pivot table - Incident Category by Month report

Alex Ng · ‎12-25-2014

Hi community,

Has anyone create report of Incident Category by Month in a Pivot Table format such as followed?:

I cannot seems to find the right field to group it by months. Anyone has any ideas?

Thank you.

tltoulson · ‎12-26-2014

Hi Alex,

As indicated by Anurag, pivot table reports only allow you to work with existing fields which means the whole date-time. That gives you a couple options in order of increasing difficulty:

- Use a Trend Chart as indicated by Anurag

- Create a month field and a business rule to populate it, you can make it readonly and not even show it on the form

- Create a custom report using a UI Page/UI Macro and GlideAggregate

View solution in original post

gyedwab · ‎03-30-2018

With Explore Analytics you can do this easily from any pivot:

When you select a date-time field (e.g. "Created"), Explore Analytics allows you to group it by any part of the date-time:

You can also group them separately, like in this pivot comparing month over month by year:

It's all real-time and can be published to ServiceNow dashboards or elsewhere. You can try Explore Analytics for free for 30 days here, and a single user license for a year starts at $300/year.

chidanandadhath · ‎01-03-2019

Hi gyedwab,

I have a requirement to create similar kind of report, Could you please let me know step by step procedure in creating the above report.