1 Reply Latest reply: Jul 13, 2016 10:23 PM by Wei Chong Tan RSS

    Finding the median of the max daly result per month

    Wei Chong Tan

      Hi,

       

      I would like to have a bar chart that shows the monthly result of the Median of the Maximum daily results.

       

      I.e Consider I have data that that have the time stamp and the performance resut. First, I would like to calculate the max for each day, then I would like to know the monthly median of all these daily max. These "monthly median of the daily max" are to be plotted in a chart or a table.

       

      Can I use set analysis for this? I have been cracking my brains and trying to search online but to no avail. I would really appreciate the help.

       

      Thank you all in advance.