Hello Tableau Community!
I am currently working on a report where we want to see the add and losses of customers across our different tiered internet products. The report would ideally show adds and losses month over month.
The relevant fields I have in the data set are:
-Bill Period
-Days prorate (we just need to set this equal to "zero")
-Account Number
-Internet Speed
In terms of logic, if let's say an account that has 1 Gig internet speed is in February, but not in January, then that would be considered an "add". If they are in January, but not in February, then they are treated as a "loss".
Does anyone have any thoughts on how to write such a calculation in Tableau?
Thanks in advance for the assistance.
Hi Charlie,
My initial thoughts are to just do a count of account number and then do a table calculation 'difference from previous month'. This will achieve your goals without stuffing around with variations of internet speed etc.
You could configure this with an additional clause to only calculate on clients that 'have' an internet speed but the base calc would remain on count of account number.
HTH
Peter
