What do I get out of it?
Solve bugs faster and improve your customer satisfaction.
How does it work?
- You import your Airtable data with your bug tracker in an Actiondesk sheet.
- You create a calculated column to return the time it takes to fix a bug.
- 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.
- 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:
- Download this Bug tracker template.
- Go to the "Bugs and issues" table.
- At the right of the table, add a column. Rename the field and call it "Fixed date".
- Click on the column header and pick "Customize field type" in the dropdown.
- Choose "Formula" as your field type.
- In the Formula tab, write: =DATEADD({Opened date},{Opened date},'day')
- In the Formatting tab, uncheck "Include a time field".
- 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:
- Create an Actiondesk sheet called "Airtable bugs".
- Import the Airable table "Bugs and issues" in Actiondesk. See how here.
- 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
- 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,>
- Create a new sheet called "Bugs Dashboard".
- In "Dashboard", in B2 to B4, write:
- 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")
- Then, copy and paste this formula in C3 and C4.
- In D2, write the formula =C2/SUM($C$2:$C$4)
- 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.