For this table, I want to calculate %UA Negative such that when A = B then count all the Negatives in the UA column and divide that by total number of results where A = B.
So for A=1 and B=1, %UA Negative = 1/2 = 0.5
I tried creating a calculated field:
IF [A] = [B] THENSUM(IF[UA] = 'Negative' THEN 1 ElSE 0 END)/COUNT([UA]) END
Getting the error: Cannot mix aggregate and non-aggregate comparisons or results in 'IF' expression
Use ATTR() in your condition
Please find the soln attached.
is this what you looking for ..
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...