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

[Ulrich Jugl]

Can you use an aggregation to achieve what you need? Try By Week Sum / By Month Sum / By Quarter Sum / By Year Sum to get these kind of aggregates.

[Ravish Shetty]

sorry, i am PA newbie. where exactly this change should be? in the indicator as below? the field selection doesn't seem appropriate

[Ulrich Jugl]

Check out the tab "Other" on the screen above and select from the Default time series field. Alternatively, open up the Scorecard view of your indicator. On the right upper area you should see the Time series as well. Sorry for not being clear in naming.

[G1 · Accepted solution]

"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"