5 Replies Latest reply on Aug 15, 2018 10:03 AM by Naveen B

    Percent retained over five years

    Kim Domholt

      Hello.

       

      I am developing an events dashboard for our events team. One of the things they want to know is for the same annual event, how many unique people attended 1, 2, 3, 4, or 5 times and then the percentage of the total. I can do this easily in Excel, so would think i can do it in Tableau, but have not been able to figure out the formulas that would make this possible. I am attaching my sample Excel file so you can see what i am trying to accomplish in a graph.

       

      In Tableau I can create the table that shows the Total column using the Anaylsis>Totals but don't know how or if that can be used in a calculation.

       

       

      Any ideas would be greatly appreciated.