What are you trying to achieve?
A percentage of uptime based on a response to a ping @ :22
How are you trying to achieve it?
I’m using the [[inputs.net_response]] plugin to see a servers uptime. I’m sending a tcp ping at :22 and using the response from that.
I’ve formed 2 queries,
count of result code where the result is “success”
count of result code where the result is anything
divide success/all using the transform panel
if I divide success/all i should receive a percentage of successful results. However, I receive NaN as the result of the divison. The number of successful / total queries is correct - 6 hour time frame * 60 minutes * 10s interval = 2160 entries.
What did you expect to happen?
I would expect that the division would return “1” which I could then turn into a percentage.