10 Replies Latest reply on Jan 5, 2018 7:55 AM by Julian Wigman

    Creating a Report/Query for Incidents that report After hours work (including holidays)

    Pitmac1 Apprentice

      Hey ServiceDesk Pals,

       

      I have been tasked to show the amount of incidents that our analyst do after hours between the hours of 5pm-7am. including holidays. Then a second query that is a copy of the first with the criteria of any status that is not "Awaiting Acknowledgement". From this report I would be able to show the volume of calls our analyst do vs. the amount of work completed.

       

      I believe I can figure out the time constraint part of the query but i'm hung on the including holidays part..

       

      What would be the best way to approach?