Cannot zoom into my data points

1

I am graphing a temperature(y-axis) value over a datetime(

Capture
Capture1890×815 88.1 KB
x-axis) value in grafana from a mySQL database, very straight forward. Although I cannot zoom in on my data. I can only view it in on the 24h time frame. Would anybody know why?

2

When you say you “cannot zoom in”, how are you trying to do this, and what
happens when you do so?

Can you change the timescale (top right of the dashboard) and get either a
smaller or larger period of time than 24 hour to be shown?

Have you specified a fixed 24 hours in the query somehow?

Antony.

3

in order to see my data I select the 24h relative time range first.
If I then select any other relative time range it says no data available.
If I click and highlight the area I want to zoom in, on it says no data available.
I have 3000 data entries into this table. I want to be able to scroll through them over time.
It does not appear to be so straight forward in Grafana.

4

in order to see my data I select the 24h relative time range first.

Roughly how many data points do you have within this 24h period?

If I then select any other relative time range it says no data available.

Any other time range? Both less than, and greater than, 24h?

If I click and highlight the area I want to zoom in, on it says no data
available.

Can you copy and paste the database query being used for this panel?

Have you tried manual queries against the database for different time ranges,
to see if there’s a clue as to the problem?

I have 3000 data entries into this table.

What are:

a) the earliest timestamp?

b) the most recent timestamp?

c) the sampling interval (how often do you get a new entry in the table)?

I want to be able to scroll through them over time.

That’s an entirely normal thing to do with Grafana.

It does not appear to be so straight forward in Grafana.

Which backend data store are you using?

Antony.

5

thanks I do appreciate the help.

I have roughly 3000 data points in this 24hr time frame.
if I select higher or lower it disappears.

I have used this code to create a table called data.
I use mySQL by the way. and the database is called node_red.

USE node_red;
CREATE TABLE data(
			count MEDIUMINT PRIMARY KEY NOT NULL AUTO_INCREMENT,
			time DATETIME NOT NULL,
			SENSOR TEXT NOT NULL,
			TEMPERATURE INT NOT NULL,
			HUMIDITY INT NOT NULL);

I then insert every 3 seconds a new row using :

INSERT INTO data (time,sensor,temperature,humidity) 
values('2020-03-18 08:07:56','sensor1',21.25,61.25)

INSERT INTO data (time,sensor,temperature,humidity)
 values('2020-03-18 08:07:56','sensor2',22.5,62.5)

INSERT INTO data (time,sensor,temperature,humidity) 
values('2020-03-18 08:07:56','sensor3',23.75,63.75)

I then have this query in Grafana

SELECT
  time,
  TEMPERATURE,
  HUMIDITY,
  SENSOR AS metric
FROM data
WHERE 
  $__timeFilter(time)
ORDER BY 1
6 
INSERT INTO data (time,sensor,temperature,humidity) 
values('2020-03-18 08:07:56','sensor1',21.25,61.25)

INSERT INTO data (time,sensor,temperature,humidity)
 values('2020-03-18 08:07:56','sensor2',22.5,62.5)

INSERT INTO data (time,sensor,temperature,humidity) 
values('2020-03-18 08:07:56','sensor3',23.75,63.75)

Judging by this code snippet, you are inserting data into your table with the exact same time stamp every single time. Perhaps change '2020-03-18 08:07:56' to now() or something similar? If you continue to insert data with the same time stamp, all your data will be aggregated to that single point in time, as you are interpreting it as time series data.