Avoid duplication of SQL logic of different measurements

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.

0 1 176
1 REPLY 1
Top Labels in this Space