SQL expression to calculate the percentage

[jsanz (Jorge Sanz)]

Maybe this answer I posted in another thread on using TSVB with the Metric Output and the Filter Ratio metric may be helpful to you

Show colored heading in the Kibana Dashboard

In fact, depending on your data query you may be able to do this using the Metric output in TSVB that has what is called Color Rules where you can change the background and text color based in the metric value. In my example I want a ratio between status: OK and status: Error so after switching to the Metric output, in Panel Options I can add the color rules to use 0.5 as my threshold [image] And in the data use the Filter Ratio metric type for status: OK [image] And in the options format…