Percentage of Requests resolved with 1,3,5,10 days

Databases : MYSQL/MSSQL/PGSQL

 

Query

 

SELECT pd.PRIORITYNAME AS priority,
(SUM(CASE WHEN (a.resolvedtime-w.createdtime)/(24*3600000) <=’1′ THEN 1 ELSE 0 END)/COUNT(w.workorderid))*100 “P

Need More Help?

Are you looking for a personalized customer support? Submit your question or Call our Toll Free Number to speak with ServiceDesk Plus MSP Expert who can offer a better solution for your requirements.

Submit a Ticket
Email : sdpmsp@manageengine.com
Toll Free : 1-888-720-9500