5 Replies Latest reply on Oct 9, 2018 2:34 PM by Donald Li

    Mean and Standard Deviation in a Histogram

    Carson Cunningham

      I want to add vertical lines to this chart showing Mean, 1st STDEV, and 2nd STDEV.

       

       

      I don't want the Mean and STDEV to be based on the Bins. Rather I want Mean and STDEV based on the underlying data WHILE displaying the binned data.

       

      Using the Analytics tab to pull in a distribution band with 2 deviations yields this:

      This is not what I want because it's showing 2 deviations of counts of opportunities.

       

      I want to see 2 deviations of velocity data/ X-Axis (LC to Opportunity Create Date). And represent the overall velocities as 30 Day binned data.

       

       

      Something like this is what I hope to have ultimately: