Is it possible to show count and percentage of incidents in a report?

[Niranjan2]

Hi All,

We have a requirement where count and percentage should be shown in a report for last six months, we need count for last six month along with the %month by month. Initially i tried doing it in the reports but unsuccessful, not able to show both (count and %) on y-axis, tried doing things in PA too, for that i have used a formula indicator which can show the percentage for last six month, (formula is no of incidents in a month/ last six month incidents *100). when i run a job i'm able to see last six month data count for every month. Is there any possibility way to show last six months data same in every month. for example: if we have no of open tickets on OCT as 2, NOV as 3, DEC as 4. Then total no of counts in last 3 months would be 9. To know the percentage of it. calculation be like OCT (2/9)*100 = 22.2 %,NOV (3/9)*100 = 33.3 %. DEC (4/9)*100 = 44.4%.

[Akshata jamdar]

Hi Niranjan,

To fulfill your requirement in the report you need to select trend type which will give you count as well as percentage.

For getting more idea on this please refer below link,

https://docs.servicenow.com/bundle/newyork-performance-analytics-and-reporting/page/use/reporting/co...

Mark the answer correct and helpful if it will help you in any manner.

Regards,

Akishata

[Adam Stout]

You definitely want Performance Analytics here.  As for a rolling SUM,  you'll want to apply a time series to the widget.  You want to collect monthly then have widget do the rolling part.  You can see all the options here:  https://community.servicenow.com/community?id=community_blog&sys_id=675c5793dbbc63c85129a851ca96191c

You could have your indicator collect for 3 months every month, but I would discourage this in favor of applying a time series.

[Niranjan2]

Thanks for the response, i tried doing it with the time series in the widget. for visualization it looks good. now i'm able to see both score count and percentages on y-axis but problem is with the data, i'm looking for % of count month to month for last 3 months. for this i have taken formula indicator to show the %, where formula is (no of incidents/last 3 months incidents) * 100. note: no of incidents and last 3 months incidents are two indicators i used. when i run job it was showing data for last 3 months for every month but we are looking show data with in these months, can you please suggest a way. Thanks

[Adam Stout]

What does that tell you about your process?

In any case, you just need a formula indicator where you apply a time series to one of the indicators in the formula (but not the other).  When you select the indicator, you can apply a time series in the formula editor.

That gives a formula like this:

([[Number of new incidents]] / [[Number of new incidents / 30d running SUM]]) * 100

I don't understand what you do with this information, but Performance Analytics can do it.