5 Replies Latest reply on May 24, 2018 2:35 AM by Chris Hastie

    Weighted avg calculation

    Ayoub Briki

      Hello dear community,

       

      I'm trying to achieve something calculated using Excel via Tableau. The calculation is basically this 'SUMPRODUCT(A1:A5;B1:B5)/SUM(B1:B5)' to calculate the weighted average of returning customers for a giving cohort.

      My excel table looks like the attached picture.

      I started by calculating the %of returning users (Table calculation of percent from first()) and when I wanted to multiply this % it got messy.

      Anyone already did this or knows how to achieve this ?

       

      Thanks in advance,