I am trying to create a chart using fractiles. I have a dataset that includes APPT_ID, DURATON_MINUTES, APPT_DATE, and MONTH and YEAR from the date. I want to calculate the top 25%, middle 50%, and bottom 25% and then give the averages of each. From previous discussions, I believe I have the basis for what I need - my issue now is that I want each row to be calculated based on a group - not on the total. So the data needs to be grouped by Month and Year, ranked by Duration, and then sorted into its particular fractile and an average calculated for it. I have tried different combinations of aggr and TOTAL - but I seem to be missing something.
I've attached what I have so far - but as you can see when you select a specific month - the averages and the counts change from when all of the data is presented.
.png "Luminary Alumni"){kind=icon}