6 Replies Latest reply on Feb 7, 2019 12:50 AM by alex ra

    Comparing calculated field averages to individual values, or groups of individual values

    alex ra

      Hi all,

       

      I have a dataset where I created several calculated fields. I now need to compare the individual values in my dataset to the overall average. I want to have a plot where I have my global average, and filtered/selected individual values on the same plot.

       

      In the attached doc, you can see in sheet1 I have the global averages, and in sheet 2 I have the same calculated fields, but filtered, and colored by "hosue"

       

      1.How can I have both the global and individual values on the same graph?

       

      2. How can I filter out houses 1 through 10, have an average line for those, and compare that average line to the global average?

       

      3. How can I filter out houses 1 through 10, have an average line for those, and compare that average line to any individual values?

       

       

      In excel, I would calculate the average for whichever group I want, and plot that next to individual values. I could compare any group of data to any other group, or any individual value to any group, etc.

       

      Thanks in advance