Good morning. We'd like to show the average of the two bars in this card, and ideally it would be using a Nested Bar chart but open to other suggestions (currently using a Grouped Bar chart).
CURRENT:

NESTED BAR:

The Value is a beast mode, which takes into consideration the actual sale amount less the valuation, divided by the valuation: (CASE WHEN `Valuation` = 0 THEN 0 ELSE (SUM(`SaleAmount` - `Valuation`)) / SUM(`Valuation`) END)
The Series consists ot the two (2) stores, the bars in the cart would be Store 1 and Store 2.
Any thoughts on how we can achieve this, i.e. an average bar, or line, to show the average of both Valuation to Sale Amount Variances by Store? Thanks