Hello, I’m very new to grafana, and been doing some tests. I’m running Grafana v5.4.2 in a debian server and feeding the data at the moment to a influxdb from nodered.
I’m doing a test with temperatures from my house. When I try to create a graph, some strange behaviours. The group does not work, if I try to group data, no graph is rendered, to apear a graph I have to remove the group. But even with the graph, I don’t have data on my label (min, max, avg, current).
A copy of my query (this is just test data)
{
"xhrStatus": "complete",
"request": {
"method": "GET",
"url": "api/datasources/proxy/2/query",
"params": {
"db": "nodered",
"q": "SELECT \"temperature\" FROM \"temperature\" WHERE (\"nodeId\" = '1') AND time >= now() - 24h;SELECT \"temperature\" FROM \"temperature\" WHERE (\"nodeId\" = '2') AND time >= now() - 24h;SELECT \"temperature\" FROM \"temperature\" WHERE (\"nodeId\" = '3') AND time >= now() - 24h",
"epoch": "ms"
},
"data": null,
"precision": "ms"
},
"response": {
"results": [
{
"statement_id": 0,
"series": [
{
"name": "temperature",
"columns": [
"time",
"temperature"
],
"values": [
[
1545305621796,
"20.2"
],
[
1545306242330,
"20.13"
],
[
1545306778314,
"20.18"
],
[
1545307322720,
"20.18"
],
[
1545310925896,
"20.18"
],
[
1545323070880,
"20.07"
],
[
1545325271937,
"20.07"
],
[
1545325743076,
"20.11"
],
[
1545326673765,
"20.11"
],
[
1545328615182,
"20.06"
],
[
1545328871996,
"20.06"
],
[
1545329135690,
"20"
],
[
1545330736848,
"19.99"
],
[
1545332227859,
"19.94"
],
[
1545332472190,
"19.94"
],
[
1545334849793,
"19.89"
],
[
1545335800375,
"19.93"
],
[
1545336072238,
"19.93"
],
[
1545336811184,
"19.87"
],
[
1545339062815,
"19.86"
],
[
1545339732452,
"19.86"
],
[
1545341314304,
"19.81"
],
[
1545342615089,
"19.76"
],
[
1545343105697,
"19.8"
],
[
1545343332527,
"19.8"
],
[
1545345757558,
"19.76"
],
[
1545346147797,
"19.79"
],
[
1545346930638,
"19.79"
],
[
1545349340002,
"19.76"
],
[
1545350350710,
"19.73"
],
[
1545350530139,
"19.73"
],
[
1545352592307,
"19.73"
],
[
1545354192859,
"19.73"
],
[
1545356089562,
"19.79"
],
[
1545357672928,
"19.79"
],
[
1545359321300,
"19.7"
],
[
1545359881611,
"19.72"
],
[
1545361273098,
"19.72"
],
[
1545362903486,
"19.62"
],
[
1545363973956,
"19.65"
],
[
1545364896892,
"19.65"
],
[
1545365604716,
"19.61"
],
[
1545366424842,
"19.56"
],
[
1545368533268,
"19.56"
],
[
1545368906126,
"19.58"
],
[
1545369986629,
"19.55"
],
[
1545371773387,
"19.53"
],
[
1545372133502,
"19.53"
],
[
1545373048485,
"19.46"
],
[
1545373198539,
"19.53"
],
[
1545374539134,
"19.45"
],
[
1545375239762,
"19.41"
],
[
1545375673447,
"19.41"
],
[
1545376240330,
"19.45"
],
[
1545376290339,
"19.44"
],
[
1545377290899,
"19.41"
],
[
1545378942060,
"19.52"
],
[
1545379333504,
"19.52"
],
[
1545379562300,
"19.49"
],
[
1545380362701,
"19.4"
],
[
1545382933592,
"19.44"
],
[
1545382934943,
"19.4"
],
[
1545384166095,
"19.45"
],
[
1545385336941,
"19.41"
],
[
1545386473665,
"19.61"
],
[
1545386486836,
"19.8"
],
[
1545386516842,
"20.11"
],
[
1545386606872,
"20.65"
],
[
1545386766923,
"21.17"
],
[
1545386916979,
"21.68"
],
[
1545387057116,
"22.22"
],
[
1545387217169,
"22.75"
],
[
1545387427381,
"23.29"
],
[
1545387777575,
"23.83"
],
[
1545388208010,
"24.33"
],
[
1545388358031,
"23.81"
],
[
1545388728139,
"24.36"
],
[
1545388908221,
"23.8"
],
[
1545389328538,
"24.35"
],
[
1545389668762,
"24.62"
],
[
1545390119341,
"24.62"
],
[
1545391249988,
"24.64"
]
]
}
]
},
{
"statement_id": 1,
"series": [
{
"name": "temperature",
"columns": [
"time",
"temperature"
],
"values": [
[
1545306542588,
"20.31"
],
[
1545306898378,
"20.26"
],
[
1545307322720,
"20.26"
],
[
1545310922895,
"20.26"
],
[
1545325012425,
"20.04"
],
[
1545325271937,
"20.04"
],
[
1545325933318,
"20.07"
],
[
1545327644528,
"20.1"
],
[
1545328575127,
"20.04"
],
[
1545328871996,
"20.04"
],
[
1545329595851,
"20.09"
],
[
1545331307188,
"20.03"
],
[
1545331937740,
"20.03"
],
[
1545332472190,
"20.03"
],
[
1545334999937,
"19.97"
],
[
1545335860444,
"19.99"
],
[
1545336072238,
"19.99"
],
[
1545338112089,
"19.94"
],
[
1545339732452,
"19.94"
],
[
1545340533841,
"19.96"
],
[
1545341194200,
"19.94"
],
[
1545342825261,
"19.89"
],
[
1545343332527,
"19.89"
],
[
1545344236628,
"19.94"
],
[
1545344996966,
"19.87"
],
[
1545346930638,
"19.87"
],
[
1545347528762,
"20.02"
],
[
1545350530139,
"20.02"
],
[
1545350770854,
"20.04"
],
[
1545352372153,
"20.02"
],
[
1545353883444,
"20.02"
],
[
1545354192859,
"20.02"
],
[
1545356969953,
"19.93"
],
[
1545357672929,
"19.93"
],
[
1545358070620,
"19.97"
],
[
1545360081742,
"19.96"
],
[
1545361273098,
"19.96"
],
[
1545362533381,
"19.96"
],
[
1545363633791,
"19.97"
],
[
1545364896893,
"19.97"
],
[
1545366794967,
"19.99"
],
[
1545367015077,
"19.99"
],
[
1545368533268,
"19.99"
],
[
1545370376743,
"20.03"
],
[
1545371773387,
"20.03"
],
[
1545372133503,
"20.03"
],
[
1545372438158,
"20.02"
],
[
1545373578744,
"20"
],
[
1545373629159,
"20.02"
],
[
1545374989557,
"20"
],
[
1545375630030,
"20.02"
],
[
1545375673447,
"20.02"
],
[
1545376900761,
"20.02"
],
[
1545377110789,
"20.06"
],
[
1545378912033,
"20.16"
],
[
1545379333504,
"20.16"
],
[
1545380142580,
"20.16"
],
[
1545380242638,
"20.11"
],
[
1545382664772,
"20.1"
],
[
1545382933593,
"20.1"
],
[
1545383625660,
"20.11"
],
[
1545383895919,
"20.03"
],
[
1545385036658,
"20.03"
],
[
1545386046683,
"20.03"
],
[
1545386473665,
"20.03"
],
[
1545387027098,
"20.21"
],
[
1545387547398,
"20.55"
],
[
1545389518718,
"21.06"
],
[
1545390119341,
"21.06"
],
[
1545390599373,
"20.99"
],
[
1545391209904,
"21"
]
]
}
]
},
{
"statement_id": 2,
"series": [
{
"name": "temperature",
"columns": [
"time",
"temperature"
],
"values": [
[
1545306512612,
"20"
],
[
1545306828340,
"19.93"
],
[
1545307322720,
"19.96"
],
[
1545310922895,
"19.96"
],
[
1545324782219,
"19.93"
],
[
1545325271937,
"19.93"
],
[
1545325903265,
"19.99"
],
[
1545327604518,
"19.94"
],
[
1545327864722,
"19.92"
],
[
1545328871996,
"19.92"
],
[
1545329785964,
"19.9"
],
[
1545330956933,
"19.93"
],
[
1545331177083,
"19.96"
],
[
1545332472190,
"19.96"
],
[
1545334159331,
"19.93"
],
[
1545335960581,
"19.93"
],
[
1545336072238,
"19.93"
],
[
1545337231638,
"19.92"
],
[
1545339732452,
"19.92"
],
[
1545340253738,
"19.92"
],
[
1545340473796,
"19.92"
],
[
1545342795217,
"19.89"
],
[
1545343332527,
"19.89"
],
[
1545343796224,
"19.92"
],
[
1545344306671,
"19.89"
],
[
1545346930638,
"19.89"
],
[
1545346958553,
"19.9"
],
[
1545347208643,
"19.86"
],
[
1545347798861,
"19.9"
],
[
1545350530139,
"19.9"
],
[
1545350590780,
"19.96"
],
[
1545353032746,
"19.92"
],
[
1545353913499,
"19.9"
],
[
1545354192859,
"19.9"
],
[
1545356809851,
"19.92"
],
[
1545357320138,
"19.85"
],
[
1545357672929,
"19.85"
],
[
1545360331804,
"19.87"
],
[
1545361273098,
"19.87"
],
[
1545362313333,
"19.89"
],
[
1545363743840,
"19.83"
],
[
1545364896893,
"19.83"
],
[
1545366824977,
"19.79"
],
[
1545368415869,
"19.83"
],
[
1545368533268,
"19.83"
],
[
1545370136647,
"19.77"
],
[
1545371773387,
"19.77"
],
[
1545372133503,
"19.77"
],
[
1545372137926,
"19.82"
],
[
1545373398652,
"19.76"
],
[
1545373728782,
"19.76"
],
[
1545374799395,
"19.77"
],
[
1545375459913,
"19.79"
],
[
1545375673447,
"19.79"
],
[
1545376660578,
"19.77"
],
[
1545376830703,
"19.75"
],
[
1545377771289,
"19.75"
],
[
1545379333504,
"19.75"
],
[
1545379962489,
"19.72"
],
[
1545380452737,
"19.69"
],
[
1545381363644,
"19.71"
],
[
1545382933593,
"19.71"
],
[
1545383365339,
"19.73"
],
[
1545383715711,
"19.75"
],
[
1545384806481,
"19.73"
],
[
1545385517129,
"19.71"
],
[
1545386536843,
"20.23"
],
[
1545386736916,
"20.81"
],
[
1545386856938,
"20.99"
],
[
1545386987048,
"21.32"
],
[
1545387807633,
"21.85"
],
[
1545390038901,
"22.09"
],
[
1545390119341,
"22.09"
],
[
1545390128969,
"22.37"
],
[
1545390519334,
"21.85"
]
]
}
]
}
]
}
}
Thank You all
