Multilevel Pivot Report - Group by Percentage?

[mathiasjohansso]

Hi!

I have a requirement from a customer, where they want a Multilevel pivot table to see Task SLA's based on percentage, BUT, they want to aggregate the Business Elapsed percentages to group them together in <25%, <50%, <75%, <=100% groups.

Is this possible to achieve with Reporting?

EXAMPLE:

[Dennis R]

Not without  a lot of gyrations. I think the easiest way to do this would be to create a custom table and run a periodic scheduled job to update it with the data, and then run your pivot report against that.

Performance Analytics can handle it if you don't mind the data being accurate on a daily basis; that is, you'd see the data accurate as of midnight last night. Even then, I'm not 100% sure that PA can do pivot tables, I'd have to dig into it a bit more than I have time to right this second.

You might could put together some reports using report ranges, but I'm not sure if they would work right since I don't think the percentage fields are updated on access like that, so your mileage may vary. Even then, I don't think report ranges apply to pivot tables, but I might be wrong about that.

To be blunt, exporting the data and manipulating it in Excel is probably your easiest bet here. But if you're really motivated, none of the other options work, and want to give option #1 above a try, let me know and I'll help out as much as I can. Reporting aggregates is the Achilles heel of ServiceNow in my humble opinion, I really do hope that they put some time and effort towards improving it at some point.

Hope this helps,

--Dennis R

[shekharnavhakar]

Hi,

You can not achieve this requirement using only reports, Here you need to go with custom table or UI Page.

If You go with  Custom table ten you need to create business rules on SLA table which is not best practice, So i suggest you go with UI page.

Hope this helps,

Shekhar 

[Adam Stout · Accepted solution]

I think you can get something similar to this with a report using report ranges.  You can't use them on a multilevel pivot but you can do it with other report types (like a bar).  Also, you can't do cumulative, but you can create buckets, (< 25, 25-50, 50-75, 75-100, 100+).

For more, I would look at PA as this should give you a lot more tools and would allow you to trend this and breakdown by different key factors (like assignment group).

[mathiasjohansso]

Thanks! I was able to create a Bar report with a "Grid" and that should be sufficient to meet the requirements!