I've been trying to perform a custom calculation on a single field and display the result as a gauge or indicator that can be filtered - the field I'm trying to calculate has values between 1 & 10 and the calculation I'm trying to perform is:
Percent of values between 9-10 (minus) percent of values between 1-6
I'd like to be able to use a formula along the lines of ( (countif(field >= 9) / countif(field >0)) - (countif(field <= 6) / countif(field >0)) )*100 and just display the result as the value for a gauge or indicator
Ian