With Multi Value or Multi Value Column I can compare 1 gauge value with 1 target value. But is it possible to compare 1 gauge value with 2 target values like this:
Gauge Value = Income
Target Value 1 = vs LY
Target Value 2 = vs Budget
I don't believe you can compare more than one using the card. The multi-value card only supports one target value. You could create a custom brick using html, css, javascript. Or use a table card with beast modes
% Change vs LY: (SUM(`Income`) - SUM(`LY_Income`)) / SUM(`LY_Income`) % Change vs Budget: (SUM(`Income`) - SUM(`Budget_Income`)) / SUM(`Budget_Income`)
