Question

How to subtract month in lookml

  • 12 November 2021
  • 1 reply
  • 31 views

Can we subtract months form ${created_date} in lookml. 

Eg: ${created_date} - 13 Months

which should give me the last 13 month data


1 reply

Depends on the database, in bigquery you could do it this way :

sql: DATE_ADD(${created_date}, INTERVAL -13 MONTH)  ;;
 

Reply