Showing "Invalid number" at "Status panel"

Grafana
1

We installed “Status panel” plugin to monitor the 200 servers.
We added the query which contacts InfluxDB and fetches the data.
The query at Grafana panel looks like:

FROM default stats WHERE host =~ /^$Host$/
SELECT field (stat1) mean ()
GROUP BY time ($__interval) fill (null)
FORMAT AS
ALIAS BY Stat 1

We get the data in the format of percentages like 12.34, 0.45, 99.05 etc.,
Now the issue is:
We entered the number threshold values(critical and warning) at “options” of the status panel. But on the stats board it is showing “Invalid number” for the given stats.
In below image, we can observe the Invalid number error.

Screenshot from 2017-11-17 15-51-55
Screenshot from 2017-11-17 15-51-551067×216 13.3 KB

In below image, we are showing the configuration of number threshold.

stat1
stat11224×433 36.2 KB

The above configuration is same for the stat2 also.

Can anyone help us to resolve this error?.

Thanks.

2

What does your query return?

https://localhost:3000/t/using-grafanas-query-inspector-to-troubleshoot-issues/2630

3

Hi @torkel
My query returns the values in float format like 12.34, 43.89, 97.67 etc.,
Now, we modified the aggregation parameter from Last to Avg. Now it is showing the numbers.

Screenshot from 2017-11-17 20-08-57
Screenshot from 2017-11-17 20-08-571288×355 6.95 KB

What does the Avg mean ?.
How can we see the latest incoming metrics to visualize, since we have changed the Last to Avg ? and how can I know that the metric is coming from which server?.

Thank you…

4

Can you show the response from your query ? Maybe the last point is null since you use fill(null) in your query.

https://localhost:3000/t/using-grafanas-query-inspector-to-troubleshoot-issues/2630

5

Hi @torkel,
Yes, you are correct.
In the response, it shows null.

52:Array[1510931660000,null]
53:Array[1510931665000,null]
54:Array[1510931670000,null]
55:Array[1510931675000,null]
56:Array[1510931680000,null]
57:Array[1510931685000,null]
58:Array[1510931690000,null]
59:Array[1510931695000,null]
60:Array[1510931700000,null]

How can we modify this?.

Thank you…

6

change fill(null) to fill(none)

7

Hi @torkel
It solves my problem. Thank you very much.