Skip to main content

Hello Tableau Community!

 

I am trying to figure out a calculation and I am stumped. I want to know the number of new adds or losses by different internet speeds.

 

For instance, if John didn't have a bill in January but had a bill in February, he would then be considered a "Add"

 

Vice versa, if Michelle had a bill in January but not one in February, she would be considered a "Loss"

 

Calculating New Add/LossesUltimately, we'd like to be able to have an aggregation of the total number of losses and adds similar to the example below.

 

Screenshot 2Does anyone have any thoughts on how to best accomplish this? Thanks in advance for your assistance.

 

Charlie

3 respuestas
  1. 5 feb 2024, 23:11

    Hi @Charlie Mouy​ 

    Yes, if you use Prep this is easier to do - leave the visualisation for Desktop and do the data prep wor in Prep.

     

    ----------------------------------------------------------------------------------------------------------------

    Please upvote my helpful replies & choose Select as Best Answer if it really is the best :)

0/9000