There is a table panel in our Grafana Dashboard which connects to self hosted OpenSearch DB Datasource and lists some metrics for a load test for a product. Each product refers to one index in OpenSearch DB which can be selected from a dropdown in dashboard. The header of that table panel reads User Action, SampleCount, Average (sec), 90 Percentile (sec) and ErrorCount. Now currently all transactions of all products have a color threshold for <3 for green cell color, 3-5 for yellow cell color and 5< for red cell color, for values only in 90 Percentile (sec) column of table. Now we want this threshold value to be changed for some specific samples/transactions for each product. For example , may be for one transaction of one product it could be like < 15 s - Green, 15–25 s - Yellow,> 25 s - Red and for another transaction it could be like < 5 s - Green, 5–15 s - Yellow,> 15 s - Red
and these customizations, we can change any time. This could be case for 5 out of 100 transactions , for rest 95 transactions we want color threshold for <3 for green cell color, 3-5 for yellow cell color and 5< for red cell color. If a solution is present, is it feasible for 1000s of transactions ? Is it possible to achieve with our existing setup of OpenSearch and Grafana.
-
What Grafana version and what operating system are you using? -Grafana 12.01 , Windows OS 11
-
What are you trying to achieve? Highlight cell background with different colors based on numeric values
-
How are you trying to achieve it? In table panel , through Config from query results transformation.
-
What happened? Cells are not highlighted as per desired colors
-
What did you expect to happen? Cells should be highlighted with color based on value for specific transactions
-
Can you copy/paste the configuration(s) that you are having problems with? No
-
Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were. No errors
-
Did you follow any online instructions? If so, what is the URL? No