I'm trying to use values coming from InfluxDB to build a piechart in grafana.
The data is stored as field in the DB and not as tag due to the great number of different values
I suppose piechart panel is expecting value being stored in fields and metric being stored as tag so extracting a numeric value and a string value both from influxdb fields is not working.
Is there a workaroud to this issue ?
I've also tried many Transformations to no result.
Query is similar to:
SELECT "CPU" AS "RunTime", "Prog" AS "Program" FROM "JOBS" $timeFilter
SHOW FIELD KEYS from JOBS
name: JOBS
fieldKey fieldType
-------- ---------
Prog string
CPU integer
Grafana: 7.5.1 ( github latest Docker Image )
grafana-piechart-panel: both 1.6.1 and beta
I'm trying to use values coming from InfluxDB to build a piechart in grafana. The data is stored as field in the DB and not as tag due to the great number of different values I suppose piechart panel is expecting value being stored in fields and metric being stored as tag so extracting a numeric value and a string value both from influxdb fields is not working. Is there a workaroud to this issue ? I've also tried many Transformations to no result.
Query is similar to:
SELECT "CPU" AS "RunTime", "Prog" AS "Program" FROM "JOBS" $timeFilter
Grafana: 7.5.1 ( github latest Docker Image ) grafana-piechart-panel: both 1.6.1 and beta