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.