Forum Discussion

PhineasT's avatar
PhineasT
Helper I
3 years ago
Solved

Create Date Time and Shortest Wait Time Measures

I am working on a dashboard that provides various Date and Time outputs. I need to create a measure or two that will show the 'Date and Time' (in one) associated with the 'Shortest Wait Time' (in ...
Need Help
lbendlin's avatar
lbendlin
Super User
3 years ago

Create a table variable (via SUMMARIZE)  of the tickets for the current filter context, include the ticket duration  (probably ignore the tickets without end time),  and then do a MINX on that table variable.

PhineasT's avatar
PhineasT
Helper I
3 years ago

Beyond my skill set.

Can you provide, or do you have a link to, an example of what your are recommending?

    • PhineasT's avatar
      PhineasT
      Helper I
      3 years ago

      Here is my first attempt.

      The actual 'Shortest Wait Time' for the date chosen (Sept. 19, 2020) is 00:16.49 (hh:mm:ss); However, the measure returns 12:16:00.

      Did I do something wrong, or do I need to change something so that the output is 00:16:49?

       

      Data Source -

       

      • lbendlin's avatar
        lbendlin
        Super User
        3 years ago

        Use the FORMAT function to tame that datetime value into a duration value.