SQL expression to calculate the percentage

[saintjohn]

Hi experts,

I have a dataset like below, separated with data range.
Field name is set to "test" where number of "≧-∞ and < 1" is 1, and "≧1 and <+∞" is 15.
What I'm trying to do is to add a metric element in the center which shows percentage of "≧1 and <+∞" which is 93.75%.
What is the best SQL expression on a metric element to calculate the percantage?

[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…