Forum Discussion

rcascarano's avatar
rcascarano
New Member
3 years ago

Visualize/quantify gaps in time between successive start and end times for IDs with multiple records

I am collecting data from multiple devices and need some way of visualizing the "data gaps" between runs. For example, generally these devices stop logging data for just a few minutes in between runs...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

There is a visual setting for date format. I would use that to try to get it to display the minutes - I think it's just buggy; it won't follow your date formatting column settings either. It wants a date format similar to this in the settings box (but I've never tried getting it to display time before, just date):

MM/df/YYYY hh:mm

 If you have a measure or calc column that gives the actual duration between dates that you want to highlight, you can pre-filter on that or make a bookmark. I made a video doing something semi-similar here (but not for time gaps, just expiring soon): 

https://youtu.be/fgCWlXLu-c4

rcascarano's avatar
rcascarano
New Member
3 years ago

Thanks. I've done something similar with the Gantt visual in the past (showing records of same type in the same row using start and end dates), but it seems like it doesn't behave the same with time in the equation.

 

Attached is an example of some of my data. You can see that the record with the inset shown isn't displaying correctly (the actual data is 10 pm to 11:21 am, but it is showing 24 hours beginning at 10 am). This is occurring across records and causing a lot of weird overlap that doesn't exist.

 

Data types are correct, etc. Have calculated duration and used that instead of end date and same problem occurs. 

 

Any thoughts? Can anyone confirm/deny if Gantt visual just does not properly support time?

 

    • rcascarano's avatar
      rcascarano
      New Member
      3 years ago

      Thanks. I had come across that thread but I think the granularity of the time data I have makes it a bit too cumbersome. I've come up with some another solution to sort of solve my problem... calculating the duration difference between successive records and conditionally formatting those that are greater than we'd like.

       

      Not quite what I was shooting for with the Gantt visual, but works well enough.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Yeah, calculating the difference and making a bookmark button that filters for > whatever threshold maybe. The conditional formatting "bars" in tables seem to stand out really well as a size indication.