Grouping time in intervals of 30 minutes

[Shahith]

Hi,

I have two columns, one is the Date and the other is the count, the date column is in 10-minute intervals, I need to group that in 30-minute intervals to show the flow of the count every 30 minutes, how can I do that?

Any help is greatly appreciated!

[WaltShpuntoff]

Look into the class function.

https://help.qlik.com/en-US/sense/August2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ConditionalF...

-ws

[rwunderlich · Accepted solution]

You can create a new field in the script as 

Timestamp(Floor(Time, 1/48)) as Bucket

-Rob