search

grafana / grafana-infinity-datasource

CSV, JSON, GraphQL, XML and HTML datasource for grafana.
https://grafana.com/docs/plugins/yesoreyeram-infinity-datasource
Apache License 2.0
706 stars 94 forks source link

[Bug] Floating-Point Precision Loss in JSON Data Source with Infinitely Datasource #893

Open iXingo opened 1 month ago

iXingo commented 1 month ago

Describe the bug

When using the Infinitely Datasource in Grafana to create a JSON data source, the returned data includes a decimal value of 0.8. However, while the data can be correctly returned as a decimal using CURL, Grafana displays the data as 0, losing the precision and converting the floating-point number to an integer.

Steps to reproduce

  1. Create a JSON data source using Infinitely Datasource in Grafana.
  2. Ensure the JSON data includes a decimal value, such as 0.8.
  3. Use CURL to request the data and verify that the decimal value is correctly returned.
  4. Display the data in Grafana and observe that the decimal value is shown as 0 (after setting decimal to 2, it becomes 0.00) instead of 0.8. image

Note: bugs will be fixed only if enough information provided to reproduce the issue

Sample Data

Here is a sample JSON data:

{
  "value": 0.8
}

Screenshots

CURL Response

image

Grafana Display

image

Version Details:

Additional context

This issue seems to be related to how Grafana handles floating-point numbers in JSON data sources. It appears that the precision is lost when displaying the data in Grafana. This issue does not occur when using CURL to fetch the data directly.

anndavism commented 1 month ago

Adding a comment that this is something I just ran into as well. It seems that grafana/infinity (not sure which), limits the precision to a single decimal point, no matter what the actual data resolution is for the data returned by the query. EDIT It seems to be a display option for the dashboard/panel "decimal", not supported by many visualization options.