2 Replies Latest reply on Nov 7, 2018 10:01 AM by Ombir Rathee

    first, second, third, ... x purchase | Loop function Tableau

    Kay Rohde

      Hey guys,

       

      i have a big problem, i found a solution to show the first purchase, second purchase etc. like below:

      loop2.PNG

      loop3.PNG

      But for example if i have like 100 purchases it is not really efficent to create 100 calculation fields. The solution would be a loop but i did not found any option to do a loop in Tableau.

       

      loop.PNG

      I attached my workbook if anyone has an idea for this problem.

       

      Thank you very much.

       

      Kay