Creating a graph showing how long it takes Dev to close tickets

Platform discussions
,
1

Hi. I’m sure I’m not the first with this need, and hoping there’s a straightforward way of doing this :slightly_smiling_face:
I want to create a graph that shows the median number of days it took our development department to close tickets. I would like this graph to show if we’re improving or not. Ideally, it could show this by month, and perhaps stacked by severity. So, I could see that perhaps in January it took 5.3 days to close a ticket, but in February this improved and went down to 5.1 days. And if possible, it would be stacked by severity, showing that it was 3 days for blockers and 7 days for high-priority issues.
Is there something out of the box? Or, if not, how can I achieve this? (Ideally, also over already existing tickets without a need for automation to start a timer on them, etc. - but, if there’s no other way than I’ll be happy to hear of any good way to do it.)
Thanks!

2

Hi @utagger ,

I believe you can accomplish this natively with a few extra columns, automations, and the native dashboarding capabilities within Monday.

The columns you will need:

  • Date Column - To track Created Date
  • Date - To track Closed Date
  • Formula Column - To Track the difference between those two dates

Date Column 1/Created Date: This column will be populated by an automation “When Item is created, Set Created Date to today”
Date Column 2/Closed Date: This column will be populated by an automation “When status changes to closed, set closed date to today”
Formula Column will be populated by a formula that will look something like this " WORKDAYS({Created Date},{Closed Date})" - you may need to tweak this formula if you want it to be just work days vs days and if your column names are different.

Once these columns are created and the automations are set up, you can then create a new view on this board for a chart to accomplish this. Select the Chart Widget and go to settings where you will customize the chart:
image
image
I would select the “Date Closed” column for this setting
image
This is where you can select the priority column so it stacks by priority
image

I know this is a lot of information so let me know if you have any questions while getting this set up!

3

Hi! We have done this for our support tickets.

You will need

  1. Creation Date
  2. Closure Date
  3. Formula calculating the open and close date
  4. IF({Date Created}<>“”,ROUNDDOWN(DAYS(TODAY(),{Date Created}),0),0)

See the screenshots below:
image
image
image
image
image
image
If you have multiple boards:
image
image
image