Forum Discussion

PhineasT's avatar
PhineasT
Icon for Helper I rankHelper I
3 years ago

Display Dates with Wait Times by Slicer

Seeking assistance creating Cards that display 'Wait Times'.

The unique output desired would include a slicer-type action that allows user to chose a day on the calendar by specifc date and/or day or week. Also, a slider that allows user to chose an hour segment of a specific day and/or day of week - providing the following output in different 'Cards' -
          1. User should be able to select an hourly time range for a given day and Power BI should display the
              'average wait time per hour' for the hour chosen hour.
          2. User should be able to select a given week and Power BI should display the day and time in which the
              'average wait time' was the shortest amount of time during that chosen week, showing the date and time
              of shortest wait, and the length of that wait time in hh:nn:ss (hours, mins, secs).

Is this possible?

Test data attached.
Column          Type
Date               Date
InTime            Custom (h:mm)
OutTime         Custom (h:mm)
WaitTime        Custome (h:mm:ss)

TicketNumberTicketDateInTimeOutTimeWaitTime
S156/3/20196:58 AM7:08 AM0:10:39
S166/3/20196:58 AM7:12 AM0:13:22
S236/3/20196:58 AM7:09 AM0:10:57
S176/3/20196:59 AM  
S246/3/20196:59 AM8:16 AM1:16:44
S186/3/20197:00 AM  
S256/3/20197:01 AM7:29 AM0:28:33
S196/3/20197:01 AM  
S266/3/20197:01 AM7:10 AM0:08:55

 

No RepliesBe the first to reply