Hello,
I have a set of data that gives me the state of a light every minute. I would like to sum the amount of time the light was in a certain state and display in a graph as separate occurrences. Below is the graph I would ultimately like to get:
I have attached the data set as well.
Thanks!
Hi - In the data set doesn't have any Occurrence Id. So this can't be grouped with Occurrence. However, since each occurrence is for 1 mutes, then this can be clubbed to create this viz. Check if this help.
Thanks Manideep,
I guess first step then is there a way to separate out consecutive green status into occurrences? Ultimately I'd like to put a goal line/time for each occurrence so I can visualize how much longer or shorter it takes for one occurrence.
Thanks!