This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
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]
