I am trying to build a chart that will display the follwing metric on a monthly level
Resolution Time: 85% in 15 calendars days/100% in 45 calendar days
This is what i did so far:
Created two calculated fields to show how many tickets were reolved within 15 days (and 45)
Created a percentage calculated field that devides the field from point 1 by the items created
The problem i have is that an issue is with overlapping monts, meaning, if an issue was created in the end of November let’s say and was solved in the begining of December (meeting the “less than 15 days rule”), the cretaed will be marked in Nov while the reolved is Dec.
This creates some wierd values
Any idea how to improve my data?
Can the cound of the reolved be the created date somehow?