Fractile with AGGR on two dimensions but including only one dimension on table
I have data containing dates, days of week, and customerIDs, and I am trying to calculate top quartile for the number of distinct customers per day of the week. For example, as 1st of April is Thursday, I would like to get what is the top quartile for number of distinct customers within all Thursdays in my data. I could easily get this to work by adding Day of the week as another dimension, but then I cannot use this as a bar graph.
I managed to calculate the average number of distinct customers per weekday with following: