8 Replies Latest reply on Aug 31, 2018 6:51 AM by Ken Flerlage

    Show running distinct count across dates

    Eva K

      I have a data set as shown below

       

      I want to display a running distinct customer count across the dates when the criteria is met.

       

      So final output should be shown below

       

      I have attached the twbx file as well as the dataset.

       

      I want the rolling count of companies,

      see below:

      6/6/2018 count will be 1, company DEF

      6/13/2018, it will be 2, XYZ & DEF

      6/15/2018, it will still be 2 because we already counted XYZ and DEF

      7/5/2018, it will still be 2 because we already counted XYZ and DEF

      7/6/2018, it will be 3, XYZ, DEF & ABC