Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a chart where Time is in X axis. Time is hh:mm TT format. We want to display the X axis in 15 mins interval though database is capturing data in every minutes.
Could you please help on this.
Thanks,
Sarif
Hi
Try this may be
timestamp(ceil("Time",1/96),'hh:mm') as 15minInterval,
Bruno
I don't think it is possible.
As of now you can only define min and max value for axis.
Hi
Try this may be
timestamp(ceil("Time",1/96),'hh:mm') as 15minInterval,
Bruno
wow...thats great..it working thanks a lot... what should be logic if I make it 5 mins interval?
Could you please explain the logic as well
Regards,
Sarif
HI
=timestamp(ceil("Date",1/288),'YYYY-MM-DD hh:mm') FOR 5 MM
as there is 288 x 5 mm in 24 hours
or there is 96 x 15 mm in 24 hours
Ragards
Bruno
Hi Bruno,
I am facing an issue while implementing the 5 mins interval.The first 4 intervals are showing erratically in the x axis.again they are adding up 15 mins instead of 5 in the rest. Can you please help.
Hi
Are you sure there is data between interval 00:05 and 00:20 ?
Bruno