How to get half an hour display of data in chart!!

[Anonymous]

Hi ,

Based on the articles and my friends suggestion, I have managed to get the 30 minutes display as 'mycurrentfiled'.

I want to display the data like this

during working hours 08:00...08:30 and so on until 17: 30.

I have used it as an dimension 'mycurentfiled.' after chnaging the datefield in the load script.

But i am unalble to ahieve the require result.

At the moment i have this in my calculated dimension

IF(Hour(Interval(created_at,'hh')) >= 8 AND Hour(Interval(created_at,'hh')) <=17 ,Hour(Interval(created_at,'hh')))  

Now i am replacing with 'mycurrentfiled'

These are the screenshots

pic:1

IF(Hour(Interval(created_at,'hh')) >= 8 AND Hour(Interval(created_at,'hh')) <=17 ,Hour(Interval(created_at,'hh')))(with the reference to this)

PIC 2:

'mycurrentfield' as calculated dimension used.

Any help pls.

kind regards,

Vamsi.

[sunny_talwar]

I am confused, what is the difference between the two screenshots?

[Anonymous]

hi,

First screenshot is showing how i wanted but there is 30 minutes interval is missing.

Second screenshot i have used this:

ime(floor(frac(created_at)*48)/48+floor(created_at), 'hh:mm') AS Created_30Min

Thasts the chart it is showing.