Skip to main content

Hello Tableau Community!

 

I am trying to calculate the adds and losses for our internet products. The information we do have is:

  • The Billion period (month/year)
  • The Account numbers
  • The Product

 

For instance, Account 500 wasn't billed in January 2024, but was billed in February 2024 so would say that's an "Add"

 

Calculating total Adds and LossesVice versa, if an Account was billed in January 2024, but not billed in February 2024, that would be considered a Loss. In this example, those would be accounts 200 and 400.

 

imageIn summary, we would like to say we have 1 Add and 2 Losses. Does anyone have any thoughts on how I can accomplish this through Tableau?

2 respostas
  1. 5 de abr. de 2024, 23:38

    Hello @Deepak Rai​ 

     

    Thanks for the reply. I tried to perform the calculation you provided, but my results are different. Do you know why that's the case?

     

    Hello @Deepak Rai​ Thanks for the reply. I tried to perform the calculation you provided, but my results are different. Do you know why that's the case?

0/9000