Cumulative Last 6months Active Records

[SrinivasM366]

Hi

I am facing the issue with cumulative active count historical data last 6mnoths? How can i achieve it?

[abirakundu23]

Hi @SrinivasM366  ,

To achieve this requirement, you can leverage Performance Analytics.

Create an Indicator Source with the condition Active = true, followed by an Automated Indicator using Count as the aggregation. Configure the collection frequency as daily, weekly, or monthly, depending on your reporting requirements.

For data collection, you can enable a Daily Data Collection Job. If historical data is required, you can also use a Historical Data Collection Job.

Finally, create a Data Visualization / Time Series visualization in Platform Analytics and apply a Last 6 Months date range to display the historical trend.

Below link for Historial Data concept : https://www.servicenow.com/docs/r/now-intelligence/performance-analytics/t_RunHistoricalDataCollecti...

Please mark helpful & correct answer if its worthy for you.

[SrinivasM366]

@abirakundu23  I had already done everything. currently getting the calculation Month wise, But what I actually need is the cumulative calculation, including the previous month's backlog
So, the exact solution I need is: the total backlog should be calculated cumulatively by carrying forward the previous month’s backlog and adding the current month’s value.