The problem starts when looker suggests that you can use sql as a filter expression inside a measure, but I have been looking around and I can’t find anything.
I need to filter a measure based on a condition. example:
measure: dinamyc_tons {
type:sum
sql: ${Tons}
filters: [month: (month calculated by another dimension)]
}
It is easy to add month: “December” or month: “12” but instead or hardcoding the filter and the measure, i need it to be dinamyc and change based on the value provided by another dimension.
if you stop typing after filters:[] , looker throws an error that says:
Expecting '[', 'string', 'numeric', 'yes', 'no', 'asc', 'desc', 'sql', ';;', 'expression', 'html', 'js', 'identifier', '-', '*', got ']'
from there i understand i can then use sql to perform the filtering action but i can’t find how, can you guys help me ???