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

# LOD doubt

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.