Hello!
I have question related to drill fields on a measure. From my understanding, drill fields will utilize these 3 components for the filters set:
I recently encountered a situation where the results for my drill field were correct when clicking on total_sum and total_payment, but incorrect when clicking on percentage_1. When clicking on percentage_1, the drill field results were not filtered using the filters applied on the numerator and denominator. Instead it showed all results filtered to only the first 2 components I listed above. I’ve tried to apply the same filters to percentage_1 as I have for total_sum and total_payment, however, I received the following LookML Error: 'filters:' is not supported for measures of non-aggregate type 'number'.
Does anyone have a good workaround for this?
measure: total_sum
type: sum
sql: ${column1}
filters: [
filter1: yes,
filter2: no,
filter3: yes
]
measure: total_payment
type: sum
sql: ${column2}
filters: [
filter1: yes,
filter2: no,
filter3: yes
]
measure: percentage_1
type: number
sql: ${total_payment} / ${total_sum}