Legend does not show min, max and current numbers

Grafana
1

test_temp
test_temp1920×1080 174 KB

2

What Grafana version? What datasource? Please use the query inspector and include request/response here.

3

Grafana v5.3.4 (69630b9), InfluxDB 1.7.1

4

{
“xhrStatus”: “complete”,
“request”: {
“method”: “GET”,
“url”: “api/datasources/proxy/1/query”,
“params”: {
“db”: “bigroom”,
“q”: “SELECT distinct(“value”) FROM “Temp” WHERE time >= now() - 30m GROUP BY time(1s) fill(null)”,
“epoch”: “ms”
},
“data”: null,
“precision”: “ms”
},
“response”: {
“results”: [
{
“statement_id”: 0,
“series”: [
{
“name”: “Temp”,
“columns”: [
“time”,
“distinct”
],
“values”: [
[
1543224398000,
“22.500”
],
[
1543224428000,
“22.500”
],
[
1543224458000,
“22.500”
],
[
1543224488000,
“22.500”
],
[
1543224518000,
“22.500”
],
[
1543224548000,
“22.500”
],
[
1543224579000,
“22.500”
],
[
1543224608000,
“22.250”
],
[
1543224638000,
“22.500”
],
[
1543224668000,
“22.500”
],
[
1543224698000,
“22.500”
],
[
1543224728000,
“22.500”
],
[
1543224758000,
“22.500”
],
[
1543224788000,
“22.500”
],
[
1543224818000,
“22.500”
],
[
1543224848000,
“22.500”
],
[
1543224878000,
“22.500”
],
[
1543224908000,
“22.500”
],
[
1543224938000,
“22.500”
],
[
1543224968000,
“22.500”
],
[
1543224998000,
“22.250”
],
[
1543225028000,
“22.250”
],
[
1543225058000,
“22.250”
],
[
1543225088000,
“22.500”
],
[
1543225118000,
“22.500”
],
[
1543225148000,
“22.500”
],
[
1543225178000,
“22.500”
],
[
1543225208000,
“22.500”
],
[
1543225238000,
“22.250”
],
[
1543225268000,
“22.500”
],
[
1543225298000,
“22.500”
],
[
1543225328000,
“22.250”
],
[
1543225358000,
“22.250”
],
[
1543225388000,
“22.250”
],
[
1543225418000,
“22.500”
],
[
1543225448000,
“22.250”
],
[
1543225478000,
“22.250”
],
[
1543225508000,
“22.250”
],
[
1543225538000,
“22.250”
],
[
1543225568000,
“22.250”
],
[
1543225598000,
“22.250”
],
[
1543225628000,
“22.250”
],
[
1543225658000,
“22.250”
],
[
1543225688000,
“22.000”
],
[
1543225718000,
“22.000”
],
[
1543225748000,
“22.250”
],
[
1543225778000,
“22.000”
],
[
1543225808000,
“22.250”
],
[
1543225838000,
“22.000”
],
[
1543225868000,
“22.000”
],
[
1543225898000,
“22.000”
],
[
1543225928000,
“22.000”
],
[
1543225958000,
“22.000”
],
[
1543225988000,
“22.000”
],
[
1543226018000,
“22.000”
],
[
1543226048000,
“22.000”
],
[
1543226078000,
“22.000”
],
[
1543226108000,
“22.000”
],
[
1543226138000,
“22.000”
],
[
1543226168000,
“22.000”
]
]
}
]
}
]
}
}

5

Values are returned as strings - that’s your problem.

6

how can I be, then:joy:

7

data is transmitted via node-red

8

I’m not aware of node-red. But if you inspect the influxdb schema of “Temp” you should see that the value is stored as a string.

9

in what form should it come

10

number:roll_eyes: :thinking:

11

Show output please and what command. Did you do?

USE <database>
SHOW FIELD KEYS
13

influxdb_2
influxdb_2213×924 79.3 KB

14

So yes, all of your fields are of type string - that’s why it doesn’t work out as expected for you.

15

I need to send a number
thank you for your help in solving my problem

16

In the words of the InfluxDB documentation about Schemaless Design, this means:

InfluxDB is a schemaless database. You can add new measurements, tags, and fields at any time. Note that if you attempt to write data with a different type than previously used (for example, writing a string to a field that previously accepted integers), InfluxDB will reject those data.

17

as then be:joy::joy:
thank you for your help in solving my problem