2 different unit types in a table

[ab1304ps]

• What Grafana version and what operating system are you using?
  11.0.8

• What are you trying to achieve?
  I want to use 2 different unit formats within a table.

• How are you trying to achieve it?
  see screenshots below

• What happened?
  every field is displayed in kWh
  

  

• What did you expect to happen?
  Autarkie and Eigenverbrauch should be in %

• Can you copy/paste the configuration(s) that you are having problems with?
  

  
  
  
  

[grant2]

Hi @ab1304ps

Try an Override:

[ab1304ps]

tx - already tried - but I only want to override 2 out of 6 fields in the column
so when overwritting “Heute” everything is in %

tried overwrite by Regex - but wasnt successful

[grant2]

@ab1304ps

I only want to override 2 out of 6 fields in the column

Can you share the entire table here? What are the rows labeled?

[ab1304ps]

2 columns:
Metric should be the label?

[jangaraj]

Override is per column, not per row.
If you want to show different units per row, then generate cell values as a string with units, e. g. 98 %, not just 98. Of course then other table functionalities will be affected, which expect numeric values can be affected, e. g. sort, thresholds, ..

[yosiasz]

as @jangaraj said stringify it, you would of course need to use some sort of CASE statement to decide which unit it should be

[ab1304ps]

can you share a sample query how to generate cell values as a string?
I am using InfluxDB 1.11

[jangaraj]

IMHO that’s not possible. But I guess you can add additional query, where you will prepare unit data and then join (keyword “transformation”) that with metrics data and concatenate correct result - that’s “cell values as a string with units” in your case. But this approach will generate other subtasks, which you need to solve - don’t expect single task, but a few tasks (each of them can be sorted already as dedicated topic in documentation/forum) until you reach your goal.