Skip to main content
Topics#Tableau Desktop & Web AuthoringFrage von Kanupriya Dhiman
Kanupriya Dhiman fragte in #Tableau Desktop & Web Authoring
1. Sept. 2017, 18:31

customers who made purchases in more than one year

Hello Experts

 

I am trying to work on this problem "filter to customers who made purchases in more than one year". I made some calculations on first and repeated purchases but the output is not correct. The total should be 1529 as per the author.

 

Appreciate your comments on the same.

 

Thanks

 

Kanu
customers who purchased in more than 1 year.twbx
2 Antworten
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    1. Sept. 2017, 19:38

    Hi Kanu!

     

    There are many ways to achieve what you're looking for. I think the easiest would be to use a LOD calculation to calculate the number of distinct years that a Customer purchased. You can do this with the following formula:

     

    {FIXED [Customer Name] : COUNTD(YEAR([Order Date]))}

     

    If you use this in the Columns shelf in your solution tab (with COUNTD([Customer Name]) in the Rows shelf, you should get what you're looking for!

     

    Hi Kanu! There are many ways to achieve what you're looking for. I think the easiest would be to use a LOD calculation to calculate the number of distinct years that a Customer purchased.

     

    Does this help?

     

    Michael

Antwort schreiben...
0/9000