Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have the following multi KPI visualization
with dimension "YearQuarter" and measure "Spend".
I want to be able to format both the color and icon depending on whether the spend increases or decreases.
First and foremost, the icons are incorrect which I don't quite understand as I've used the following expression:
=if ( ( Sum(Spend)/Below(Sum(Spend)) ) > 1, 'lui-icon lui-icon--triangle-top', 'lui-icon lui-icon--triangle-bottom')
Secondly, I can't find any option to use conditional formatting for colors. For example, if the spend is higher compared to the previous period, the icon should be triangle-top and color green.
Is this something anyone can help with?
No one with any input regarding this?