BigValue downIsGood not working properly

[adgramigna]

Steps To Reproduce

Code snippet with needful things data. I'm aware logically this would be an example for downIsGood should be the default value of false, but for illustrative purposes, let's pretend we want less purchases on "Sinister Toys" and therefore downIsGood should be set to true.

View issue as raw text as markdown formatting is hiding some of the needed code for Evidence. I've attached a screenshot of the code just in case

  select 
      date_trunc('month', order_datetime) as month,
      sum(sales) as sales_usd,
      category
  from needful_things.orders
  where category = 'Sinister Toys'
  and (date_trunc('month', order_datetime) >= '2021-11-01')
  group by all
  order by 1 desc

with create_monthly_change as (
    select 
    category,
    lag(sales_usd) over() - sales_usd as monthly_change,
    case when month = '2021-11-01' then sales_usd end as nov_sales,
    case when month = '2021-12-01' then sales_usd end as dec_sales,
from ${orders_by_category}
)

select
    category,
    max(monthly_change) as monthly_change,
    max(nov_sales) as nov_sales,
    max(dec_sales) as dec_sales,
from create_monthly_change
group by 1

Environment

• Node version (node -v): v20.9.0
• npm version (npm -v): 10.5.2
• OS: Mac
• Browser: Arc
• Database: Duckdb

Expected Behavior

the downIsGood parameter is supposed to flip the colors for Red and Green in the comparison

Actual Behaviour

Parameter does not work. downIsGood=true has the same effect as downIsGood=false, positive numbers are green and negative numbers are red

Workarounds

None that I know of