SQL expression to calculate the percentage

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?

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

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.