test

aaa.view

dimension: fiscal_progress_days {
  type: number
  sql:
    CASE
      WHEN CURRENT_DATE BETWEEN {% date_start sales_date %} AND {% date_end sales_date %} THEN
        DATE_DIFF(CURRENT_DATE, {% date_start sales_date %})
      ELSE
        DATE_DIFF({% date_end sales_date %}, {% date_start sales_date %})
    END ;;
}