how to create time range for every 30mins and display in bar chart

[#1]

Hi, how do I create time range for every half an hour and display in bar chart? I have a list box called timediff that displays the time intervals I derived between 2 columns. I've been trying many codes but nothing just seems to work. Thanks.

[#2]

Maybe try define dimension with class() function

[#3]

Hi Rachel, you need round your actual transaction timestamp into 30 mins window.

Try like below:

LOAD *,

     Timestamp (floor(TRANSACTION_DATE,30/(24*60) )) AS TRANS_DATE_30MIN

from QVD;

Use this new field as the dimension.