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]Updated 03-02-2023
