Need to calculate percentage

Grafana Dashboards
1

  • What Grafana version and what operating system are you using?
    I am using managed Grafana

  • What are you trying to achieve?
    Need to calculate percentage of H2% in O2 after electrolysis process(as per my data)

  • What happened?
    I don’t know where the option is present yo calculate the percentage

  • What did you expect to happen?
    I need to know where the calculate option is present

2

what is your datasource?

3

Timestream is our datasource @yosiasz

4

please share some data sample with columns

it is best to do the calculation you want in the data source query itself. something like

SELECT (field_key1 / field_key2) * 100 AS "percentage" 
FROM "measurement_name" 
WHERE time < now() - 15m
5

Need to find
H2% in O2
O2% in H2
My column names are
H2%(gs-at-012),
O2%(gs-at-022)
can you please tell where can I find the option for creating this logic @yosiasz ?

6

please provide sample data. column names alone will be hard to help you

1 Like
7

sorry @yosiasz .
This is the sample data
TIME , COL NAME , MEASURE_VALUE
|2024-06-13 06:31:38.024000000 |GS-AT-012(H2%) |0.42136865854263306|
|2024-06-13 06:31:43.069000000 |GS-AT-012 (H2%) |0.4150390625|
|2024-06-13 06:31:48.059000000 |GS-AT-012 (H2%) |0.41684749722480774|

|2024-06-14 01:09:11.883000000 |GS-AT-022(O2%) |-0.03562644496560097|

|2024-06-14 01:09:16.972000000|GS-AT-022(O2%) |-0.03562644496560097|
|2024-06-14 01:09:21.972000000|GS-AT-022(O2%) |-0.035445600748062134|

I need to do this logic “H2/(H2+O2)*100” and “O2/(H2+O2) *100”
Where can I go for do this ?