Up Arrow or Down Arrow for KPIs
Use this case statement to add up and down arrows to your metrics, for instance:
case when [value_field] < lag([value_field]) over(order by [order_field]) then '▲ ' when [value_field] = lag([value_field]) over(order by [order_field]) then 'no change' else '▼ ' end || [value_field] as [value_field]
To add to this, you can also break out the up-down arrows into a separate per metric column. Maybe you find conditional formatting the entire background of the cell a bit aggressive visually.
You can use the character ⇅ (maybe if you use it multiple times just number them like "⇅.1, ⇅.2,..." etc,
Using the query above, you can then have the metric text colored / not colored, and then have a separate column which shows the up-down arrow only colored, thus reducing the amount of visual noise.
Additionally, I would recommend going into this column and setting the width to 1 for the column, so it takes up minimal width in your tables.Reply