5 Replies Latest reply on Apr 23, 2019 8:39 AM by Ewald Hofman

    Calculating number of departures, entries and changes

    Yeyner Escobar

      Hello Tableau community, I need help to perform some calculations.

      For example I have a list of people per month; I have for the month of February 2019 there were 862 people, in January of that same year there were 860 people, there is a difference of 2 people. How to show in Tableau those 2 new PersonIDs that were not in the previous month?


      In December of the year 2018 there were 856 people, how do I show that number of people who left those months?,


      From that same amount of PersonID I would like to determine how many departments changed, to be able to select from a month to compare with the previous month:



      I appreciate your help or comments about it .

      I attach a workbook with test data.


      • Añadir a la guía de conversación
        • No hay listas de palabras para Inglés -> Español...
        • Crear una nueva lista de palabras...
      • Copiar