Showing Month on Month % Increase/Decrease

SThiara · ‎Jan 17, 2024

Hi,

I have setup an airtable base to show tickets from another application (via a csv export).

For higher management, we have filtered to show how many tickets each team has and what is outstanding and closed (as well as dashboards to have further insight into these tickets).

I am unable to compare/show the % increase/decrease via Airtable. Below is in the interface but I'm hoping to show the % in the Data tab. For example Oct-Nov there was a 41% increase but I am unable to find a way of showing this.

The aim is to allow Month on Month, Quarter by Quarter and Half by Half comparisons in %.

Michael-Zimmer · ‎Jan 24, 2024

There may be multiple ways of doing this but from what I can understand you may have to create a new column to indicate the % change.

Create a formula field
percentage increase or decrease = (current month - previous month)/previous month

You might have to create a new graph to show the % changes and insert next to the one you posted. I don't think you can overlay on top. I could be wrong on so check into it.