7 Replies Latest reply on Apr 26, 2018 3:21 AM by Aymeric DE CREMIERS

    LOD Customer Order Frequency depending on date filter

    Aymeric DE CREMIERS

      Hi community,

       

      I've been struggling for weeks to do a chart similar to the Custumer Order Frequency LOD example ( Top 15 Tableau LOD Expressions ) depending on a date filter.

       

      So, based on the following dataset,

       

      • # orders from Customer 1 :
        • 1 in january
        • 1 in february

       

      • # orders from Customer 2 :
        • 2 in january
        • 2 in february

       

      • # orders from Customer 3 :
        • 1 in january
        • 2 in february

       

      We would have, considering the whole period (i.e. January and February)  :

      • 1 customer with 2 orders
      • 1 customer with 3 orders
      • 1 customer with 4 order

       

      But filtering on January only, this would update to:

      • 2 customers with 1 order
      • 1 customer with 2 orders

       

      Any ideas how to achieve this ?