Hi Guys,
I have 3 dimensions and each of them having similar values I just need the total average of all of them ( total yes % (across A,B,C) and total no %(across A,B,C)) can any one help me ?
how about
^{Updated}
create calculated fields:
yesCountA:
sum(if [A] = "Yes" then 1 end)
yesCountB:
sum(if [B] = "Yes" then 1 end)
yesCountC:
sum(if [C] = "Yes" then 1 end)
YesShare:
(yesCountA + yesCountB + yesCountC) / (count[A] + count[B] + count[C])
NoShare:
((count[a] - yesCountA) + (count[b] - yesCountB) + (count([c] - yesCountC) )/ (count[A] + count[B] + count[C])