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

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.

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    - the slicers could move to the filter pane

    - the day cards could benefit from a small multiples approach

    - the bottom left two charts don't carry a lot of information and should be replaced with something more insightful.

  • PhineasT's avatar
    PhineasT
    Helper I
    3 years ago

    Thank you for your continued assistance.

    I fiddled around with it some more this morning. This is what I have now; While being unsure of all of the 'best practices' and such.

    Please, let me know, if you would, if anything stands out to you as potentially troublesome.

    Default View -

     

    View with TicketNumber 'S16' chosen in the table visual -