Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I know how to do it using SQL scripts, but how do i do that in qlik sense?