Hello Tableau Community,
I am trying to put together a report that will look at the # of Accounts (Field: Account number) that have Internet (Field: Internal Service Type) but not Telephone (Field: Internal Service Type).
The results are matching with what I am expecting to see. Does anyone have any thoughts?
Thanks in advance for the assistance.
Charlie
@Charlie Mouy
Hi, you may create a calculated field like:
Flag Yes Internet Not Telephone:
{FIXED [Account ID]:MAX([Internet Service Type]="INTERNET") AND
NOT MAX([Internet Service Type]="Telephone")}
You may use this flag field as a filter (using the true value), or in a calculated field:
COUNTD(IF [Flag Yes Internet Not Telephone] THEN [Account ID] 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
