Forum Discussion
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...
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.
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.