Custom Calculation in Operations Dashboard

1331
1
12-18-2018 09:53 PM
Status: Already Offered
by Anonymous User
Not applicable

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

1 Comment
patrickb
Status changed to: Already Offered

Something like this could be done with a data expression