1 Reply Latest reply: Jan 3, 2014 4:09 PM by Stefan Wühl RSS

    class(), increment by standard deviation

    lin ye

      want to show a chart with count of error on y, and standard deviation group of error on x

      error is a field already in table, need to calculate standard deviation group on front end. I know i can do it in the back end, but i what to keep standard dev dynamic based on selected criteria.

       

      outcome of the chart in table format:

       

      say standard devation is 2, and mean is 20

       

      stdev group   error range

      -1                   18<=x<20         

      0                    20

      1                    20<x<=22

        • Re: class(), increment by standard deviation
          Stefan Wühl

          Your buckets are not of equal size, which is not supported by the class function.

           

          You can create two variables vSTD and vAVG:

           

          =stdev(error)

          =avg(error)

           

          and then a chart with a calculated dimension

           

          =class(error, vSTD, 'error', vAVG)

           

          and an expression

          =count(x)

           

          to show a histogram with buckets of size of the standard deviation grouped around the mean value.