Platform analytics Formula indicator to calculate previous month vs current month open incidents

[Deebika]

Hi Team,

I am working on a platform analytics dashboard and would like to display the variation between the previous month's open incidents count and the current month's open incidents count in a bar chart.

My Requirement is 

Previous month open incidents-current month open incidents

Questions:

Has anyone implemented a similar requirement?

Could you please advise:

1.Which formula indicator method should be used

2.Are there any best practices for displaying this variation in a bar chart widget?

[jeffrubinoff]

I don't understand why you are trying to do something so tortuous instead of just having a monthly count of open incidents and showing it on a line chart.

[Deebika]

Thanks for your response.

The requirement is not to show the monthly trend of open incidents. Instead, I need to display the month-over-month variation as a separate metric on the dashboard.

For example:
Previous Month Open Incidents = 120
Current Month Open Incidents = 100
Variation = 120 - 100 = 20

The goal is to show this increase/decrease value in a bar chart widget rather than displaying the monthly counts themselves.

[jeffrubinoff]

Ah, I should have remembered the answer because I documented it! But it was years ago, in my defense.

Set up an automated indicator to take a monthly count of open incidents. Create a formula indicator that runs the getChange method on that indicator. See https://www.servicenow.com/docs/r/now-intelligence/performance-analytics/get-indicator-analytics.htm... and https://www.servicenow.com/docs/r/now-intelligence/performance-analytics/PAFU-getChange_S_O_O.html. I don't know exactly how you would set up the formula, but I think you should be able to get the difference between the most recent collection period and the period before that.

I still think you need to display the results in a time series data visualization of some kind, perhaps a column. https://www.servicenow.com/docs/r/now-intelligence/time-series-visualization-types.html

[Deebika]

Not working.