4 Replies Latest reply on Sep 18, 2018 3:09 PM by Anthony Sardain

    Calculating Mean/Median using a subset of data (straightforward)

    Anthony Sardain

      Hi all,

       

      This should be relatively straightforward.

       

      I have created two calculated fields to calculate the mean and median of my data, keeping certain factors fixed. These, I presume, operate over the entirety of the data. Instead, I'd like the relevant statistics to only be calculated across data entries that are above my "CutOff" parameter – i.e. I only want to calculate the mean and median number of fatalities where "Week" > CutOff.

       

      Any help would be really appreciated!

       

      EDIT FOR CLARITY:

      I would like a table broken down by Country and sub-region ("Admin1"), where each cell contains 3 values:

      1. The number of fatalities for that region/country for Week 52

      2. The mean number of fatalities for that region/country for all Weeks 26-52

      3. The median number of fatalities for that region/country for all Weeks 26-52

       

      Where 26 is the "CutOff" in my created parameter.

       

      Thanks.