1 Reply Latest reply on Aug 14, 2013 10:29 AM by bill.cunningham

    How to make this reality?

    Anthony Armstrong

      The concept is realtively simple.  Implementation... no so much.

       

      Attached is a sample of what I think should be a simple chart of Current vs Historical.

      The circles are current performance, the bars are +/-1 standard deviation from the rolling quarter average (excludes current month), and the lines are +/-2 standard deviations from the rolling quarter average.

       

      Between floating bars, standard deviation calculations, and rolling date ranges, I just can't seem to get the pieces to fit together. Maybe I am overthinking it. Is there a simple way to build this in Tableau?