1 Reply Latest reply on Jan 20, 2014 12:51 PM by Matt Lutton

    Trouble Adding Standard Deviation Reference Line per Pane

    Yue Wang

      Hello,

       

      I was trying to replicate "controlChart2," one of the control charts in the Tableau tutorial. (Control Charts | Tableau Software)

       

      I applied the same computation for the "Std Lower Bound,"

           WINDOW_AVG(SUM(Sales))-WINDOW_STDEV(SUM(Sales))*[Standard Deviations]

      but the reference line appeared to be one straight line across the entire worksheet, rather than being re-calibrated per Pane.

       

      You will notice on the "Curret Look," that the Average is re-calibrated per Pane (working fine), but the Average Sort_LCL is a straight line across the board.

       

      Why the "WINDOW_AVG" function doesn't work here? Did I miss something? Any help is appreciated!