0 Replies Latest reply: Sep 27, 2013 8:35 PM by Nithin Kotian RSS

    Plotting  average of a standard deviation (please refer Query Below)

      I need to plot following


      Avg( Stdev (Peak WL  Group by Wafer Id) ) Group by Base Growth


      Here Base_Growth = LEFT (Wafer_id,11) 


      Please refer below query


      SELECT LEFT (a.Wafer_id,11)  Base_Growth  , AVG(stdev_PL) Avg_Stdev_PL



        SELECT Wafer_id, stdev((peak_lambda))stdev_PL

        FROM dbo.f_LED_Reactor_PL_Data  WITH (NOLOCK)

        GROUP BY Wafer_id

      ) A


      GROUP BY LEFT (a.Wafer_id,11)


      Please any input will be helpful.