- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 17, 2024 06:49 AM
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 %.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 24, 2024 05:52 AM
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.