Need cumulative trend reports

[Ravish Shetty]

hi all,

we need a trend on the incidents created but not using the opened date.

instead, we want a cumulative trend which is a sum of the total data and not just the ones created on specific data.

like example: if 100 incidents are created every month (and none of them get closed), it shouldn't show a flat 100 every month but a sum as below

Is Performance Analytics is the only way to get this?

[Harsh Vardhan]

you can use custom chart to fulfill this requirement.

adding doc link. please have a look it.

https://docs.servicenow.com/bundle/geneva-performance-analytics-and-reporting/page/administer/report...

Performance Analytics will also fulfill this requirement it support average indicators.

[David Pearson]

Performance Analytics is the easiest way to get reports like that.  You need some way of getting a count of records in existence for each of the time periods in the report.  You might be able to trick the reporting engine into calculating this for you, but PA has the ability to create an indicator record that will hold results for you.  It has a scheduled job to populate the indicator on the frequency you select (eg monthly).  Then it is really easy to report the trend because you are just reporting a value off of the indicator records.  To answer the question of "is this the only way?", no, you could also script the same functionality of creating a record on a monthly basis to collect the metric for you.  Been there, done that.  PA is way easier.

[Ravish Shetty]

I tried using PA, didn't work like i wanted , here i have posted a separate question for that https://community.servicenow.com/community?id=community_question&sys_id=1a8ec5f5db9dab009a64e15b8a96...

[wang qiuhao]

hi,David

Can you tell me how to achieve the above by Performance Analytics?