How to change the range in X axis

[mhmmd_srf]

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

[shraddha_g]

I don't think it is possible.

As of now you can only define min and max value for axis.

[brunobertels · Accepted solution]

Hi

Try this may be

timestamp(ceil("Time",1/96),'hh:mm') as 15minInterval,

Bruno

[mhmmd_srf]

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

[brunobertels]

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

[mhmmd_srf]

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.

[brunobertels]

Hi

Are you sure there is data between interval 00:05 and 00:20 ?

Bruno