Airtable: track user reported bugs

What do I get out of it?

Solve bugs faster and improve your customer satisfaction.

‍

How does it work?

1. You import your Airtable data with your bug tracker in an Actiondesk sheet.
2. You create a calculated column to return the time it takes to fix a bug.
3. You create a dashboard in a new sheet to know the percentage of bugs that have been fixed in a day, in less than 3 days, etc.
4. That's it! You can track how fast you fix your bugs.

‍

Detailed tutorial

First, let's get the data we'll work with in this example:

1. Download this Bug tracker template.
2. Go to the "Bugs and issues" table.
3. At the right of the table, add a column. Rename the field and call it "Fixed date".
4. Click on the column header and pick "Customize field type" in the dropdown.
5. Choose "Formula" as your field type.
6. In the Formula tab, write: =DATEADD({Opened date},{Opened date},'day')
7. In the Formatting tab, uncheck "Include a time field".
8. It will automatically fill all the rows of your new column with the day's date when a bug is fixed.

‍

Now, let's understand how fast you're solving user reported bugs:

1. Create an Actiondesk sheet called "Airtable bugs".
2. Import the Airable table "Bugs and issues" in Actiondesk. See how here.
3. Add a calculated column to return the time it takes to fix a bug. To do this, just create a column called "Time to fix" and use the formula =#Fixed date - #Opened date
4. Add a calculated column to return the periods of time it takes to fix a bug. To do this, just create a column called "Time to fix bracket" and use the formula =IFS(#Time to fix<1, "<1="" day",="" #time="" to="" fix<="3," "1-3="" days",="" fix="">3, "3+ days")</1,>
5. Create a new sheet called "Bugs Dashboard".
6. In "Dashboard", in B2 to B4, write:
7. To calculate the time to fix and only count bugs that have been fixed, we add a condition Status=Complete. In C2, write the formula =COUNTIFS(Airtable bugs!#Time to fix,B2,Airtable bugs!#Status,"Complete")
8. Then, copy and paste this formula in C3 and C4.
9. In D2, write the formula =C2/SUM($C$2:$C$4)
10. Then, apply the percentage format on D2
    

Good job 👍 You now have a good understanding of how fast you fix your bugs. If you have too many bugs fixed in more than 3 days (>5%), you may want to revisit the way your prioritize bugs.