Use default value of a field

Hola Paco,

If the default value stored in the DB  as a single value of a table, you should to define the table as a lookml view and include it in the model as a cross join against the fact table , for example :

    join: table_x{
      type: cross

       sql_on: 1 = 1 ;; # this sql_on condition is required in some dialects,
    }                             # removing if you experience problems with cross joins

then you should write:

 measure: customer_viewLimitQuantityDaily{
    type:  sum
    sql: CASE
    WHEN ${view_limit_quantity_daily} is null THEN ${table_x.default_value}
    ELSE ${view_limit_quantity_daily}
    END ;;
  }