Trend Report for Pivot table

[poonam_dasani]

Is it possible to create Trend report for Pivot table? I want to create a Pivot Report for all the incidents Opened this month or year. I know chart is available but didn't find anything for pivot?

[Mwatkins]

Have you looked at Multilevel pivot charts?

You ought to be able to get what you want by adding a Condition to a Pivot Chart for Opened "This Month". Is that what you are looking for?

[poonam_dasani]

Hi Matthew,

What I am looking for is to group by "opened" on a pivot table, but this groups by individual dates. I want an option to group by month/year.

Thanks,

Poonam Dasani

Service Delivery Manager, IT Service Management

American Express Global Business Travel

office: (623) 516-5981 | e-mail: poonam.dasani1@aexp.com<mailto:poonam.dasani1@aexp.com>

amexglobalbusinesstravel.com<https://www.amexglobalbusinesstravel.com/>

[Mwatkins]

Hm... It is kind of a hack, but you could set the value of a custom Month field with a business rule. Something like this:

var month = new GlideDateTime(current.sys_created_on+"");

return month.getMonthLocalTime();   // return the calculated value

I think the other way to do this would be to use Performance Analytics. Something very like this comes out of the box in the "Incident Management" dashboard:

[poonam_dasani]

Right. That's the only option I have I think. Creating a custom field and reporting on that.

Thanks,

Poonam Dasani

Service Delivery Manager, IT Service Management

American Express Global Business Travel

office: (623) 516-5981 | e-mail: poonam.dasani1@aexp.com<mailto:poonam.dasani1@aexp.com>

amexglobalbusinesstravel.com<https://www.amexglobalbusinesstravel.com/>