Help

Showing Month on Month % Increase/Decrease

166 1
cancel
Showing results for 
Search instead for 
Did you mean: 
SThiara
4 - Data Explorer
4 - Data Explorer

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. 

SThiara_0-1705502552079.png

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

 

1 Reply 1
Michael-Zimmer
4 - Data Explorer
4 - Data Explorer

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.