Hello Tableau Community!
I work for a Telecom company and we're trying to figure out the number of customers we have by internet speed. We want to look at this month over month.
In our data tables, we have customers, the customers billed amount by each month, and also the dates they disconnected.
We want to exclude the customers from our reports when and after they've disconnected internet service.
Is there a calculation that I can use to best achieve this?
Hi @Charlie Mouy
Would it be as simple as:
[Disconnected date] < today()
That would result in True or False - True means they have already had their disconnection processed and not a current customer.
I'm assuming that you can have future-dated disconnects and you still want to include those. Also "normal" customers might have a null value for a disconnect - you would need to check your data.
----------------------------------------------------------------------------------------------------------------
Please upvote my helpful replies & choose Select as Best Answer if it really is the best :)
