I had this formula that I created on an older version of Tableau to get the proportion of measurements that are >=85
COUNT(if [Dimension A]>=85 then “>=85” END)/sum([Number of Records])
With the new Tableau, i'm unable to replicate this formula as the 'Number of Records' field is not available. Is there a way to do this?
I've attached an excel sheet of what I'm trying to do. The cell highlighted in yellow is the intended output. Thanks.