cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
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]
Rate this article:
Version history
Last update:
‎03-02-2023 09:31 AM
Updated by:
Contributors