Config from query transformation

[jbleijenberg]

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

• 11.6.1

• What are you trying to achieve?
  Add a dynamic threshold via Transformations

• How are you trying to achieve it?
  I’ve added a Zabbix query, and added a “Config from query” transformation, to add a threshold based on the last* value

• What happened?
  The threshold is added, but the original query results are still shown and are drawn over the threshold

• What did you expect to happen?
  I expect only the threshold to be shown, and the results of the query to be hidden.

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

  
  
  
  
  
  
  

• Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
  No

• Did you follow any online instructions? If so, what is the URL?
  Transform data | Grafana documentation
  and the demo dashboard as reference:
  Grafana

[infofcc3]

How to Highlight the Cell with Maximum Value Dynamically

Steps to create highlight in cell Step 1: Create table in database in my case (PostgreSQL) and insert data in it. [image] Step 2: Create new dashboard in Grafana and then select your data source to fetch the data. • Click on Add Visualization [image] • Select the datasource [image] Step 3: Select table visualizations to show the data on panel using this query. [image] SELECT “device_name”, “00_hours”, “04_hours”, “08_hours”, CASE WHEN “00_hours” = MAX(“00_hours”) OVER () THEN…

follow this doc for hint…i used this config from query transformation in this post.