metrics with 0 value ( also false ) are mapped to NaN

[abenbouz]

hello Marc ,

can you please help resolving the floowing issue :
metrics with 0 value ( also false ) are mapped to NaN
ENV :

• Grafana version 7.3.4
• grafana-json-datasource version 0.7

FYI : mapping is working well with previous version ( 0.6.4 )

Regards

[marcusolsson]

Thank you for reporting this! I'll look into it 👍

[abenbouz]

thanks for you prompt action
i forget to mention that i'm using Table plugin

[marcusolsson]

Could you paste the JSON and the query you are using, so that I reproduce this?

[abenbouz]

i'm using a private backend so you don't have acess to it
but will give you some outputs 👍

Path : /client Query string : type=X&attributes=*

$.client[?(@.name=='$name')].name
$.client[?(@.name=='$name')].status.child

{
"request": {
"url": "api/datasources/proxy/9/client?type=X&attributes=*",
"method": "GET",
"hideFromInspector": false
},
"response": {
"client": [
{
"name": "XXXXX",
"status": {
"child": 0
},
"type": "X"
}
]
}
}

anyway you can reproduce it using any data with 0 as a value

[marcusolsson]

I tried with this JSON:

[
  {"number": 0, "boolean": false},
  {"number": 2, "boolean": true}
]

which seems to work

[marcusolsson]

I can reproduce it with your example. I think the error occurs when there's only one item in the array.

[abenbouz]

i don't think it related to the number of items

[abenbouz]

since i have the same behaviour with a lot of items

[marcusolsson]

Yeah, you're right.

Zeros:

• [0, 0, 0] becomes [NaN, NaN, NaN]
• [0, 0, 1] becomes [0, 0, 1]

Booleans:

• [false, false, false] becomes [NaN, NaN, NaN]
• [false, false, true] becomes [false, false, true]

Looks like it fails when all values are "falsy".

[abenbouz]

in fact in depends on the selct Json Path
if you select just one item based on some creteria you have the problem

[abenbouz]

and if you do not choose any filter like (?(@.name=='$name') it should be ok

[abenbouz]

and please note that it was working fine in previous version

[marcusolsson]

I've found the issue, and working on a fix.

[abenbouz]

perfect thanks

[marcusolsson]

Fixed in v0.7.1. Let me know if you're still having issues!

[abenbouz]

i apreciate well your reactivity :)
V0.7.1 is working like a charm
Thanks