1 Reply Latest reply on Feb 29, 2016 4:39 PM by Patrick A Van Der Hyde

    UCL Calc

    SambiReddy Chanimella

      Hi All,

       

      I have a  requirement like i need to calculate Mean,Std.dev,UCL and i tried those in attached workbook but the desired values are not accurate.

       

      My Requirement -

      Find Mean,Median and UCL

       

       

      PFA the workbook with superstore data

       

      Note : In Y-axis the field 'Date in hours' should not be Aggregated.

       

      Appreciate if someone help me out.

       

      Thanks,

      Chanimella

        • 1. Re: UCL Calc
          Patrick A Van Der Hyde

          Hello SambiReddy,

           

          So in the example supplied the view is at the level of Day and yet there are many orders per day.  I am curious if the goal in this example is actually to find the difference in date/time at the level of Order?  Understanding the level of detail is important to figure out the average...  I like to start with a crosstab view of all of the data and calculate a value in Tableau first before going to a chart view. 

           

          A view of the sample data with an expected result - would help a lot to assist you here.

           

          Thank you

           

          Patrick