Hello there o/
Someone, please, can help me understanding a problem with the Table Panel (Official one)?
From time to time I have this
The datasource is Zabbix.
The data at Zabbix is fine
The type of data is text (its a log monitoring, where I want to show in grafana the pieces where an error is found)
The grafana version is 4.2.0
Why I keep getting NaN even with data? 
Config of the table
Just a P.S.:
Has the same behaviour with or without the “Filter null values” checked. Same to the option “Sanitize HTML”
What does the query from Zabbix return?
Here’s a guide on how to troubleshoot queries.
It should look something like this:
Hello there
{jsonrpc: “2.0”,…}
id
:
1
jsonrpc
:
“2.0”
result
:
[{itemid: “305942”, clock: “1495525023”, value: “ID: 90977500304761826”, ns: “278953035”},…]
[0 … 99]
0
:
{itemid: “305942”, clock: “1495525023”, value: “ID: 90977500304761826”, ns: “278953035”}
1
:
{itemid: “305942”, clock: “1495525023”, value: “Mensagem: Parametro invalido: CHASSI_INVALIDO: chassi”,…}
2
:
{itemid: “305942”, clock: “1495525023”, value: “Versao: v20150729”, ns: “280113095”}
3
:
{itemid: “305942”, clock: “1495525023”, value: “Layout: SOMPO”, ns: “280113659”}
4
:
{itemid: “305942”, clock: “1495525023”, value: “Data: 2017-05-18 15:25:14.292”, ns: “280114285”}
5
:
{itemid: “305942”, clock: “1495525023”, value: “----”, ns: “280114736”}
6
:
{itemid: “305942”, clock: “1495525023”, value: “ID: ID”, ns: “280115219”}
7
:
{itemid: “305942”, clock: “1495525023”, value: “Mensagem: Mensagem”, ns: “280115771”}
8
:
{itemid: “305942”, clock: “1495525023”, value: “Versao: Versao”, ns: “280116299”}
9
:
{itemid: “305942”, clock: “1495525023”, value: “Layout: Layout”, ns: “280116724”}
10
:
{itemid: “305942”, clock: “1495525023”, value: “Data: Data”, ns: “280117185”}
11
:
{itemid: “305942”, clock: “1495525023”, value: “----”, ns: “280117612”}
12
:
{itemid: “305942”, clock: “1495525023”, value: “ID: 602765580327459102”, ns: “280118211”}
13
:
{itemid: “305942”, clock: “1495525023”, value: “Mensagem: Parametro invalido: PLACA INVALIDA: placa”,…}
14
:
{itemid: “305942”, clock: “1495525023”, value: “Versao: v20150729”, ns: “280119531”}
15
:
{itemid: “305942”, clock: “1495525023”, value: “Layout: SOMPO”, ns: “280119994”}
16
:
{itemid: “305942”, clock: “1495525023”, value: “Data: 2017-05-18 17:20:51.071”, ns: “280120614”}
17
:
{itemid: “305942”, clock: “1495525023”, value: “----”, ns: “280120981”}
18
:
{itemid: “305942”, clock: “1495525023”, value: “ID: ID”, ns: “280121405”}
19
:
{itemid: “305942”, clock: “1495525023”, value: “Mensagem: Mensagem”, ns: “280121919”}
20
:
{itemid: “305942”, clock: “1495525023”, value: “Versao: Versao”, ns: “280122394”}
21
:
{itemid: “305942”, clock: “1495525023”, value: “Layout: Layout”, ns: “280122814”}
22
:
{itemid: “305942”, clock: “1495525023”, value: “Data: Data”, ns: “280123246”}
23
:
{itemid: “305942”, clock: “1495525023”, value: “----”, ns: “280123639”}
24
:
{itemid: “305942”, clock: “1495525023”, value: “ID: 713080510978137660”, ns: “280124197”}
25
:
{itemid: “305942”, clock: “1495525023”, value: “Mensagem: Parametro invalido: CHASSI_INVALIDO: chassi”,…}
26
:
{itemid: “305942”, clock: “1495525023”, value: “Versao: v20150729”, ns: “280125421”}
27
:
{itemid: “305942”, clock: “1495525023”, value: “Layout: SOMPO”, ns: “280125881”}
28
:
{itemid: “305942”, clock: “1495525023”, value: “Data: 2017-05-18 17:40:22.304”, ns: “280126439”}
29
:
{itemid: “305942”, clock: “1495525023”, value: “----”, ns: “280126806”}
30
:
{itemid: “305942”, clock: “1495525023”, value: “ID: 713080510978137737”, ns: “280127326”}
31
:
{itemid: “305942”, clock: “1495525023”, value: “Mensagem: Parametro invalido: CHASSI_INVALIDO: chassi”,…}
32
:
{itemid: “305942”, clock: “1495525023”, value: “Versao: v20150729”, ns: “280128618”}
33
:
{itemid: “305942”, clock: “1495525023”, value: “Layout: SOMPO”, ns: “280129063”}
34
:
{itemid: “305942”, clock: “1495525023”, value: “Data: 2017-05-18 17:40:27.668”, ns: “280129638”}
35
:
{itemid: “305942”, clock: “1495525023”, value: “----”, ns: “280130058”}
36
:
{itemid: “305942”, clock: “1495525023”, value: “ID: 602765580327467643”, ns: “280130677”}
37
:
{itemid: “305942”, clock: “1495525023”, value: “Mensagem: Parametro invalido: CHASSI_INVALIDO: chassi”,…}
38
:
{itemid: “305942”, clock: “1495525023”, value: “Versao: v20150729”, ns: “280131928”}
39
:
{itemid: “305942”, clock: “1495525023”, value: “Layout: SOMPO”, ns: “280132373”}
40
:
{itemid: “305942”, clock: “1495525023”, value: “Data: 2017-05-18 17:40:32.509”, ns: “280132938”}
41
:
{itemid: “305942”, clock: “1495525023”, value: “----”, ns: “280133337”}
42
:
{itemid: “305942”, clock: “1495525023”, value: “ID: 713080510978137800”, ns: “280133873”}
43
:
{itemid: “305942”, clock: “1495525023”, value: “Mensagem: Parametro invalido: CHASSI_INVALIDO: chassi”,…}
44
:
{itemid: “305942”, clock: “1495525023”, value: “Versao: v20150729”, ns: “280135332”}
45
:
{itemid: “305942”, clock: “1495525023”, value: “Layout: SOMPO”, ns: “280135794”}
46
:
{itemid: “305942”, clock: “1495525023”, value: “Data: 2017-05-18 17:40:36.103”, ns: “280136341”}
47
:
{itemid: “305942”, clock: “1495525023”, value: “----”, ns: “280136713”}
48
:
{itemid: “305942”, clock: “1495525023”, value: “ID: ID”, ns: “280137173”}
49
:
{itemid: “305942”, clock: “1495525023”, value: “Mensagem: Mensagem”, ns: “280137689”}
50
:
{itemid: “305942”, clock: “1495525023”, value: “Versao: Versao”, ns: “280138179”}
51
:
{itemid: “305942”, clock: “1495525023”, value: “Layout: Layout”, ns: “281255080”}
52
:
{itemid: “305942”, clock: “1495525023”, value: “Data: Data”, ns: “281256255”}
53
:
{itemid: “305942”, clock: “1495525023”, value: “----”, ns: “281256704”}
54
:
{itemid: “305942”, clock: “1495525023”, value: “ID: 887655410172646882”, ns: “281257342”}
55
:
{itemid: “305942”, clock: “1495525023”, value: “Mensagem: Parametro invalido: PLACA INVALIDA: placa”,…}
56
:
{itemid: “305942”, clock: “1495525023”, value: “Versao: v20150729”, ns: “281258644”}
57
:
{itemid: “305942”, clock: “1495525023”, value: “Layout: SOMPO”, ns: “281259127”}
58
:
{itemid: “305942”, clock: “1495525023”, value: “Data: 2017-05-18 19:43:32.614”, ns: “281259735”}
59
:
{itemid: “305942”, clock: “1495525023”, value: “----”, ns: “281260142”}
60
:
{itemid: “305942”, clock: “1495525023”, value: “ID: ID”, ns: “281260592”}
61
:
{itemid: “305942”, clock: “1495525023”, value: “Mensagem: Mensagem”, ns: “281261112”}
62
:
{itemid: “305942”, clock: “1495525023”, value: “Versao: Versao”, ns: “281261615”}
63
:
{itemid: “305942”, clock: “1495525023”, value: “Layout: Layout”, ns: “281262072”}
64
:
{itemid: “305942”, clock: “1495525023”, value: “Data: Data”, ns: “281262537”}
65
:
{itemid: “305942”, clock: “1495525023”, value: “----”, ns: “281262910”}
66
:
{itemid: “305942”, clock: “1495525023”, value: “ID: 602765580327506750”, ns: “281263462”}
67
:
{itemid: “305942”, clock: “1495525023”, value: “Mensagem: Parametro invalido: PLACA INVALIDA: placa”,…}
68
:
{itemid: “305942”, clock: “1495525023”, value: “Versao: v20150729”, ns: “281264685”}
69
:
{itemid: “305942”, clock: “1495525023”, value: “Layout: SOMPO”, ns: “281265137”}
70
:
{itemid: “305942”, clock: “1495525023”, value: “Data: 2017-05-19 09:25:38.771”, ns: “281265707”}
71
:
{itemid: “305942”, clock: “1495525023”, value: “----”, ns: “281266086”}
72
:
{itemid: “305942”, clock: “1495525023”, value: “ID: ID”, ns: “281266517”}
73
:
{itemid: “305942”, clock: “1495525023”, value: “Mensagem: Mensagem”, ns: “281267055”}
74
:
{itemid: “305942”, clock: “1495525023”, value: “Versao: Versao”, ns: “281267522”}
75
:
{itemid: “305942”, clock: “1495525023”, value: “Layout: Layout”, ns: “281267975”}
76
:
{itemid: “305942”, clock: “1495525023”, value: “Data: Data”, ns: “281268405”}
77
:
{itemid: “305942”, clock: “1495525023”, value: “----”, ns: “281268767”}
78
:
{itemid: “305942”, clock: “1495525023”, value: “ID: 887655410172670650”, ns: “281269287”}
79
:
{itemid: “305942”, clock: “1495525023”, value: “Mensagem: Parametro invalido: CHASSI_INVALIDO: chassi”,…}
80
:
{itemid: “305942”, clock: “1495525023”, value: “Versao: v20150729”, ns: “281270536”}
81
:
{itemid: “305942”, clock: “1495525023”, value: “Layout: SOMPO”, ns: “281270981”}
82
:
{itemid: “305942”, clock: “1495525023”, value: “Data: 2017-05-19 09:33:10.393”, ns: “281271606”}
83
:
{itemid: “305942”, clock: “1495525023”, value: “----”, ns: “281271990”}
84
:
{itemid: “305942”, clock: “1495525023”, value: “ID: 713080510978181798”, ns: “281272560”}
85
:
{itemid: “305942”, clock: “1495525023”, value: “Mensagem: Parametro invalido: PLACA INVALIDA: placa”,…}
86
:
{itemid: “305942”, clock: “1495525023”, value: “Versao: v20150729”, ns: “281273795”}
87
:
{itemid: “305942”, clock: “1495525023”, value: “Layout: SOMPO”, ns: “281274245”}
88
:
{itemid: “305942”, clock: “1495525023”, value: “Data: 2017-05-19 09:35:39.297”, ns: “281274840”}
89
:
{itemid: “305942”, clock: “1495525023”, value: “----”, ns: “281275224”}
90
:
{itemid: “305942”, clock: “1495525023”, value: “ID: ID”, ns: “281275626”}
91
:
{itemid: “305942”, clock: “1495525023”, value: “Mensagem: Mensagem”, ns: “281276147”}
92
:
{itemid: “305942”, clock: “1495525023”, value: “Versao: Versao”, ns: “281276616”}
93
:
{itemid: “305942”, clock: “1495525023”, value: “Layout: Layout”, ns: “281277072”}
94
:
{itemid: “305942”, clock: “1495525023”, value: “Data: Data”, ns: “281277539”}
95
:
{itemid: “305942”, clock: “1495525023”, value: “----”, ns: “281277919”}
96
:
{itemid: “305942”, clock: “1495525023”, value: “ID: 887655410172712595”, ns: “281278456”}
97
:
{itemid: “305942”, clock: “1495525023”, value: “Mensagem: Parametro invalido: PLACA INVALIDA: placa”,…}
98
:
{itemid: “305942”, clock: “1495525023”, value: “Versao: v20150729”, ns: “281279709”}
99
:
{itemid: “305942”, clock: “1495525023”, value: “Layout: SOMPO”, ns: “281280204”}
[100 … 199]
[200 … 299]
[300 … 399]
[400 … 499]
[500 … 599]
[600 … 699]
[700 … 799]
[800 … 899]
[900 … 999]
[1000 … 1099]
[1100 … 1199]
[1200 … 1299]
[1300 … 1399]
[1400 … 1499]
[1500 … 1599]
[1600 … 1699]
[1700 … 1799]
[1800 … 1899]
[1900 … 1999]
[2000 … 2099]
[2100 … 2199]
[2200 … 2299]
[2300 … 2399]
[2400 … 2499]
[2500 … 2599]
[2600 … 2699]
[2700 … 2799]
[2800 … 2899]
[2900 … 2999]
[3000 … 3099]
[3100 … 3199]
[3200 … 3299]
[3300 … 3399]
[3400 … 3499]
[3500 … 3599]
[3600 … 3699]
[3700 … 3799]
[3800 … 3899]
[3900 … 3999]
[4000 … 4030]
Is this useful?
I dont know if can help, but I noticed this when I selected 2 days of data in a graph
(With the table usually I select 1 hour btw)
Those values look strange to me. They are not numbers. For example, value: "Layout: SOMPO" does not look like a valid value.
What does your query look like?
@tammyt Seems, a problem is in downsampling (max data points). Try to reduce time range for table panel or increase Max Data Points value.
