Hi,
I'm currently working on a time monitor that shows the activities op operators based on timestamps of movements.
I need to divide the timestamps in buckets between 06:00 & 22:00 and per every 5 minutes. I have been able to create these buckets via the data manager but if I put it in a chart I am not seeing all the buckets. I should see all the buckets between 06:00 & 22:00 regardless if they contain values or not, this is the only way we can get an accurate view on a person's activities.
Example:
Operator,Timestamp,BucketTime
F37718A,07:23,07:20
F37718A,07:26,07:25
F37718A,07:27,07:25
F37718A,07:37,07:35
Result will show the buckets 07:20,07:25 & 07:35. However I also want to see bucket 07:30 even if it is showing 0 value.
I haven't been able to find an answer on the previous topics on here so I hope someone can help me out.
Many thanks!
Wouter
