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



      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.