Forum Discussion

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

And then what?

Also, I don't understand your comment..."As it is it cannot handle tickets that are open across day boundaries."

I merely want a card that contains the date and time (just the date in MM-DD-YYYY form will do), and another card that contains the shortest wait time on that date and the time of day of that Shortest wait time. 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Let's say the "In Time" for a ticket is 11:55pm and the "Out Time"  is 02:05am.

  • PhineasT's avatar
    PhineasT
    Icon for Helper I rankHelper 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
      Icon for Super User rankSuper 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
        Icon for Helper I rankHelper 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?