Data manager buckets how to show everything between values

Wlescrauw — Fri, 27 Sep 2019 13:56:22 GMT

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

topic Data manager buckets how to show everything between values in App Development

Data manager buckets how to show everything between values