3 Replies Latest reply on Dec 15, 2016 10:55 PM by Shinichiro Murakami

    Week-by-week average on scatter plot

    Kristian Juel

      Dear Tableau community

       

      I have been attempting to overlay a week-by-week breakdown of cycle times to get an overview of how the average has varied over the past few weeks onto a scatter plot. So far, I have been able to segment the date range into weeks and implemented this as columns plotted against the cycle time. However, when I attempt to add an average line to each of these weeks the average is clearly wrong.

       

      2016-12-16 12_49_41-Tableau - testing.png

       

      Note that this is just random data. I suspect I will need to implement a window_avg function of some kind and assign this to a parameter for each week, but I have not been able to get this to work. Any help would be much appreciated!

       

      Cheers,

       

      Kristian