Weighted Averages of Summary Data
I am trying to create a pretty simple bar chart visualization based off of sumarry data but with numerous filters. The summary data that looks something like this, where I'm charting the average of X-Y average :
The issue I'm having is that the card itself is showing data averaged over X and Y (which is what I want) with quick filters for X and Y so that I can drill down into the data. However, unless the data is drilled down to a single X-Y combo the visualization is an unweighted average. Is there a way to plot the weighted average? I know I could create a weighted average but I can't see how that would work if someone wanted to filter the data down.