10 Replies Latest reply on Jan 27, 2016 3:36 PM by Hannah Staroselsky

    Calendar date parameter

    Hannah Staroselsky

      I need to count a number of open Help Desk incidents for any single day during any date range.

      For each incident I have Date_Opened and Date_Closed.

      I want to create a Calendar Date parameter, for each day in a date range I need to calculate the number of incidents, that have been opened before this day and either closed after this day of never closed.

       

      Please let me know if you have any ideas.

      Thank you,

      Hannah