Trend report by total number of records cumulatively

[VL10]

I am wanting to make a trend line showing the total number of records month by month in a table like cmdb_rel_ci (with some filters added).

I am using a Time Series Report, and Trend By Created, per Month, Aggregation of Count.

I can get a report that shows me how many records were added in each month but I want to see a line of cumulative record count (going up).

What am I doing wrong?

[Tai Vu · Accepted solution]

Hi @VL10 

Performance Analytics is what you're looking for. In PA, you can set the Indicator Source to retrieve all data from now to the past (with other specific conditions) and schedule a job to run on a monthly basis to collect data. This way, you will be able to achieve the cumulative visualization.

Sample.

Cheers,

Tai Vu