2 Replies Latest reply on May 30, 2017 4:27 AM by Peter Cox

    Accumulated Events Occurring Within N Days of One Another

    Peter Cox

      Dear all,

       

      The following link/page below shows how to get the events occurring within N days of one another.

      Show Only Events Occurring Within N Days of One Another | Tableau Software

       

      I am looking for the "sum of the unique customers" per "period" where the event has another event N days before (30 days in our case). So the events where another event occurred 30 days before the event. Therefore, I adjusted the formule in the attached workbook a bit and I have the events per customer. Next step is to get this accumulated unique customers per month, but I don't know how to get this fixed with the LOD's.

       

      Can someone help me with this? Please find attached the adjusted workbook for your reference. Please skip the caption because I haven't changed this.

       

      Thanks in advance.

       

      Best,

      Peter