Need cumulative trend reports

[Ravish Shetty]

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

[Ravish Shetty]

G1, can you help with a similar query 

here is the posted question.

https://community.servicenow.com/community?id=community_question&sys_id=9a5deac0db296b04afc902d5ca9619c6

[Armacar2]

Hi, I was looking to do a cumulative trend report for all new VIs and I get this done by adding a "365d running SUM" time series to the indicator, however, after a year, the trend started to go down and then up again instead of continue going up or at least flat, so I realized PA cannot maintain the cumulative trend beyond the time series aggregation period of time correctly, so, I created a new indicator source with the extra conditions shared here "created on today & created before today" and wow! the cumulative trend was generated automatically, now I don't have to apply any time series to the indicator. Thank you so much G1, you saved my day.

[learn nv]

Hi Armacar,

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

[PaulSylo]

Hi - Can you help me with the query you use to get this cumulative trend?

Regards,

Paul

[PaulSylo]

Can you pls share the query once?

Regards,

paul