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
PhineasT's avatar
PhineasT
Helper I
3 years ago

Let's assume such an occurence is not possible. 

That all actions happen within a 24 hour period, with most happening between 04:00 and 20:00.

Seems I should be able to click on a calendar slicer - picking a day/date; There may be hundreds of 'Tickets' on that date/date. This action should populate card with the 'Shortest Wait Time' on that given day/date.

Is this not possible?

Something like this, except the desired ouput is 'Shortest Wait Time' rather than 'Earliest Start'.

Earliest Start =
MINX (
    CALCULATETABLE (
        Table_Roster,
        ALLEXCEPT ( Table_Roster, Table_Roster[Date], Table_Roster[Name] )
    ),
    Table_Roster[Start]
)

  

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 -