6 Replies Latest reply on May 3, 2018 8:04 AM by Daniela Corraini

    Running Distinct Count - considering P6M

    Daniela Corraini

      Good afternoon,

       

      I have a database with store codes and sales. What I need is to analyse in Tableau how many unique stores we achieved in the last 6 months, but considering each month.

       

      For example:

      - February'18: Distinct Count of Store Codes from September'17 to February'18

      - January'18: Distinct Count of Store Codes from August'17 to January'18

      - December'17: Distinct Count of Store Codes from July'17 to December'17

      ...

       

      Can you help me?

       

      Regards,

      Daniela