Searching for 'duration' in this forum, I've come across some use cases that sound close to mine (using scripted fields), but they all seem to bring in an additional complexity.
My application is looking at data from motion detectors. I have data coming from any given sensor that resembles the following in my Discover view:
[motion 1] value = true, time: 09:50:00
[motion 1] value = false, time: 09:14:00
[motion 1] value = true, time: 09:00:00
My goal is to create a chart for the day that fills in color for the period of 9-9:14, then picks up again at 9:50, etc.
Put another way, I want to visualize duration using the changes between true/false as my start/stop event.
A slightly more complex take on the same problem would be in string fields, where I get data in plain language form from what is essentially a heat map of the area to represent traffic patterns.
[density 1] value = High, time: 10:50:00
[density 1] value = Medium, time: 09:45:00
[density 1] value = Low, time: 09:35:00
[density 1] value = Medium, time: 09:00:00
My goal here is the same, to chart the time periods in which these various conditions were met based on when the value changed.
It seems straightforward in my mind—any help would be greatly appreciated.