Create report that shows count of tasks by each assigned to per month

[mbal1]

Hi,

I'm trying to create a table style report to show the number of completed tasks per month by each assignee.   Something like this:

However, I am unable to do this in a table as my options to trend are only available on column charts.

Any advice would be much appreciated.

Thanks,

Mandeep

[Community Alums]

What version of ServiceNow are you on? In Helsinki, you can do a multi-level pivot table, which might be what you're looking for.

Cheers,

Tim

[mbal1]

Hi Tim,

We are on Geneva, and it also has the multilevel pivot table option but when I use that I have no option to view the data by month.

Thanks,

Mandeep

[manredd]

i do not think this type   of report is possible unless you create a column for month update through script

and create a graph

[manredd]

you can try Custom Chart Data Generation - ServiceNow Wiki i am not sure it supports pivot table