Hello Tableau Community!
I am trying to write a calculation that shows me the # of accounts that have two types of equipment. I know the below calculation will show me when an account has either one or the other, but I only want to see the accounts that have both
Can someone help provide assistance?
My aggregation is Count Distinct by Account #.
Thanks in advance for the assistance.
Charlie
2 个回答
@Charlie Mouy
Hi, you may try with something like:
{FIXED [Account #]:COUNTD([Equipment])>=2}{FIXED [Account #]:IF COUNTD([Equipment])>=2 THEN "Swap" ELSE "No Swap" END}If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador
