Hello,
In my project we have a lot of measurements which tend to share the same common SQL logic applied for a column.
For example:
measure: column_apple_agg {
type: number
sql: floor(sum(${apple_weight}));;
}
For simplicity I put only 2 SQL functions (floor and sum), but it can easily be more complex.
Is there any way to avoid copy/paste of this common logic in SQL applied for a column?
Something like 'templated' measure or any other templating mechanism which could help here.
I did my best searching in the docs and checking all DRY Looker's recommendations, but couldn't find an answer.
Thank you.