Mysql timeseries query

Hi ,

I am using below query but i want to show time on x-axis.can any one please suggest on it.

Go to axes tab and change x-axis option to time

Hi Torkel,

Thanks for the reply.when i changed to time on axes tab in x-axis data is not populating as below.

@torkel Could you please help on it

not sure what your problem is the graph looks correct, your only returning one data point with time now()

@torkel
I need a line graph to be plot based on time.
Do I need to change the query for line graph instead of datapoint.If so please help me with the query.

Your data needs to include time column, your query just generates the now time, so each data point have the same time

@torkel Please help with the query

I can’t until you show what data columns you have