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

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

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 -

  • 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.