Pivot table - Incident Category by Month report

[Alex Ng]

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.

[Anurag Tripathi]

Hi Alex,

What you want to achieve is difficult to be done through month wise as pivot table is made only on existing fields n the table and there is no field that holds month.

However, using a trend chart can definitely give you the desired result, month wise and category wise data.

Create a report like this

Check and uncheck "Display grid" field to get more/less data.

Let me know if it helps

[gyedwab]

If you want true pivots in ServiceNow, you can do it through Explore Analytics

Defined just by dragging the fields:

They are live and support drill-down, if you're logged in to ServiceNow.

It supports multi-level, like this Category/Subcategory by Month:

[tltoulson · Accepted solution]

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

[VAIGAI_KOTHANDA]

Hi,

Has anyone created report for number of created incidents per hour   in a Pivot Table using custom charts format such as followed?:

Regards,

Vaigai k