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.