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.
I don't think it is possible.
As of now you can only define min and max value for axis.
Try this may be
timestamp(ceil("Time",1/96),'hh:mm') as 15minInterval,
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
=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
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.
Are you sure there is data between interval 00:05 and 00:20 ?
Retrieving data ...