Steps to Recreate the report
Create the following formulas in the "Request" table. Please use the exact names so that the subsequent formulas can be used as is.
if(isnull("Responded Time") = 0 , (unix_timestamp("Responded Time")-unix_timestamp("Created Time"))/ (60 * 60 ),NULL)
Target response time
If("Priority"='Critical', '95%', If("Priority"='High', '90%', if("Priority"='Normal', '85%', if("Priority"='Medium', '80%', if("Priority"='Low','75%', NULL)))))
Target
If("Priority"='Critical' and "Time to respond in hours"<0.5, 'achieved', If("Priority"='High' and "Time to respond in hours"<2, 'achieved', if("Priority"='Normal' and "Time to respond in hours"<4,'achieved',if("Priority"='Medium' and "Time to respond in hours"<8, 'achieved',if("Priority"='Low' and "Time to respond in hours"<24, 'achieved','not achieved')))))
Percentage achieved (This should be added as an "Aggregate formula")
100*(Countif("Request"."Target"='achieved'))/Count("Request"."Target")
To create the report using Analytics Plus, populate your rows and axes as shown below:
Rows:
Created time (Month and year)
Priority (Actual)
Target response time (Actual)
Data:
Percentage (Actual)
To create more interesting visualizations using your data, please check out our demo page.