Hello Tableau Community!
I work for a telecom company and I want to create a report that looks at our customers that have 'only' internet service (the service are listed under 'Internal service type'). In this case, I want to exclude customers that have both Internet + Phone, Phone, Etc.
In my report, I am currently looking at customers by Account numbers and their service types
I've attached a screenshot.
Thanks in advance for any assistance you can provide.
Charlie Mouy
3 réponses
Hi @Charlie Mouy
{ FIXED [Si Acct Nbr] : (IF COUNT([Sa Internal Srv Type])>1 OR MAX([Sa Internal Srv Type])<>'Internet' THEN 'Other' ELSE 'Internet' END)}Drag it to the filter shelf and choose the "Internet" option
Try this and let me know if it is correct
Thanks
Said
(Please upvote all my answers and select the best one if you find them helpful)
