3 Replies Latest reply on Apr 23, 2018 12:13 PM by Jim Dehner

    Compounding Average from week to week

    Kelly Uhl

      Hello,

       

       

      I am trying to create a bar graph that displays the average days it takes to accomplish a task. For example, The first week of January it takes an employee 2 days to accomplish a task, the second week of January it takes 5 days, but on the graph it is displayed at 3.5. So, (2+5)/2 weeks.

       

      How could I create this calculation in Tableau?

       

       

      Thanks!

       

      Kelly