Need cumulative trend reports

Ravish Shetty · ‎10-22-2018

hi all,

PA newbie here.

we need a trend on the vulnerable items data 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 VI's are created every month (and none of them get closed), it shouldn't show a flat 100 every month but a sum as below

however, this is the result I get which is not cumulative

i have created an indicator as below

This is the indicator source

i have created 2 data collector jobs. one to collect data for the past 3 months and one for daily data collection

G1 · ‎10-22-2018

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

If above is the requirement, then Add another condition in the indicator source created before today

But if you also want the condition for not closed as in below example, then add the condition closed is empty and that should get you the data you are looking for

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

View solution in original post

Chandu29 · ‎10-22-2018

@adamstout - Is this possible in PA, currently we don't have the time series aggregation to present the cumulative data.

Kindly request you to provide your inputs.

learn nv · ‎09-19-2021

Hi Ravi,

Could you please suggest the solution for similar problem i am facing. I posted my question in below link.

https://community.servicenow.com/community?id=community_question&sys_id=27b41557db62b01039445ac2ca96192d