I have a visualization that shows user's average productivity per hour by month with a reference line and distribution that shows the group average for each individual month (Floats up or down based on the monthly averages) see attached book. Essentially I am trying to create a custom box plot using average instead of median and setting my own custom upper and lower ranges. Users are evaluated on whether they are within the range.
I want the reference lines each month to stay fixed when users are filtered out of the visualization. I've tried using a fixed calculation or a lookup calculation to fix the average reference line however this makes the reference average the same for all months. Also since my data goes back past our current fiscal year these calculated fields pull all data no just the current fiscal year. Any help is appreciated.