Question

Looking to Create Adjusted Date Dimension Based on Min Date of 2 Columns


Hello - I am working with some messy data that needs to be adjusted in certain cases, but don’t have access to the upstream database. The gist of the problem is I need a new field that is based off of the minimum between 2 dates in other existing columns. Have tried the following approaches:

 

dimension: adjusted_date {

    type: date

    sql:  CASE WHEN ${field1} > ${field2} THEN ${field2}

          ELSE ${field1} 

          END ;;

  }

 

dimension: adjusted_date {

    type: date

    sql:  min(${field1},${field2}) ;;

  }

 

Both approaches pass LookML validation, but neither works in Looker charts or filters. I receive errors that look like the following:

The Snowflake database encountered an error while running this query.

SQL compilation error: error line 9 at position 1,604 too many arguments for function [MIN(TO_CHAR(field1, 'YYYY-MM-DD'), TO_CHAR(field2, 'YYYY-MM-DD'))] expected 1, got 2

 


This topic has been closed for comments