Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Wlescrauw
Contributor
Contributor
‎2019-09-27 09:56 AM

Data manager buckets how to show everything between values

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

 

608 Views
0 Likes
0 Replies