5 Replies Latest reply on Feb 8, 2017 11:12 AM by Shinichiro Murakami

    How do I create a calculated field which is the average of selected rows of data?

    Vicci Barrett

      I have created a box plot of University league table scores over time and have picked out one university to show on a trend line across the chart.  I would like to add another reference line that shows the average of a sub-set of universities (for example, Bolton, Cumbria and Manchester Metropolitan) across the chart, but for the life of me cannot work out how to do it.  I'm guessing I need to add another calculated field but I can't seem to combine the IF statement with an aggregation.  What formula to I need in the calculated field?

      Many thanks in advance