0 Replies Latest reply on Oct 29, 2015 11:11 AM by WordsworthA

    How to query amount of Incidents and Request resolutions in a certain time frame

    Rookie

      Hi,

       

      Been trying to find away around this but can't seem to find a solution. Basically on the default dashboard we have for the Service Desk I just want a query on there which displays the amount of tickets (both incidents and requests) that have been resolved in the last 7 days and then group it by which analyst has resolved it. I can then apply a fancy HTML template and you can see who's resolved the most calls in the last 7 days on your dashboard.

       

      I can get this to work for just incidents or just requests but Incident has it's own Resolution Business Object as does Request and I'm not sure how to query both of them at once. Any help with this would be much appreciated.

       

      Thanks,

      Adam