1 Reply Latest reply on Oct 21, 2018 8:42 PM by Tushar More

    LOD doubt

    Aayush Desai

      I am working on the LOD functionality and have been doing the problems from these link : https://www.tableau.com/about/blog/LOD-expressions

      Top 15 Tableau LOD Expressions (Practical Examples)

       

      Problem : What percent of customers from each cohort (year of acquisition) purchased at least 1, 2, 3, N times in 2014?

       

      On the 15th Problem, which I am trying to solve it in a different way, I am stuck at the last step.

       

      If you look at the screenshot, I have the count of the number of purchases each user makes in the year 2014. Also I have them grouped by their year of joining date. However I am not able to count the number of users with joining date in 2011 and number of purchases = 2. Please let me know if you did not get enough clarification. Thank you.

       

      I want something like this:

       

      Year of joining date: 2011

       

      Count(Users who made 3 purchases in 2014) : 10

      Count(Users who made 7 purchases in 2014) : 6

       

      Year of joining date: 2012

       

      Count(Users who made 3 purchases in 2014) : 9

      Count(Users who made 7 purchases in 2014) : 3

       

      For all the years till 2014

      PS: Numbers mentioned above are for example and not derived.