Good day everyone. I was trying to build a nested bar, but wanted the gray at the back to be determined by whatever aggregation we use for the calculation. So for example in the following graph, rather than showing me the bar in the back as the SUM of all the individual bars, it'd show it as the actual average of the underlying data (not the AVG of the underlaying bars).
This would be nice as it'd be able to easily highlight outliers, but I haven't been able to find a way to achieve what I want. Perhaps I should be looking at a different card?