1 Reply Latest reply on Feb 8, 2016 7:09 PM by SambiReddy Chanimella

    Standard Deviation Error

    SambiReddy Chanimella
    SambiReddy Chanimella Feb 8, 2016 11:50 AM

      Hi All,

       

      Iam trying to find SD and UCL for the hours between 'Order date' and 'Ship date' in Quarter wise. So the 'hours' calc which is in Row shelf  should not be Aggregated

      so changed to dimension(Non-Aggr) but for finding SD and UCL iam summing it while using functions. Can someone please look into it and correct me where im making error.

       

      Plz find dashboard attached

       

       

      Thanks,

      Sambi

      • 99 Views
      • Categories: Calculations, Dates & Times
      • Tags:
        • 1. Re: Standard Deviation Error
          SambiReddy Chanimella
          SambiReddy Chanimella Feb 8, 2016 7:09 PM (in response to SambiReddy Chanimella)

          Hi All,

           

          Can anyone have a look into above Problem and I took UCL formula as UCL = Mean+(3*SD) and what am finding difficult is calculations on Non-Aggr field which placed in row shelf. Based on UCL i need to give Cond.Formatting like above UCL the color of data points should change.I tried to mockup data in above workbook which is replica of my issue..I got stuck here so experts pls guide me how to get over this issue