Drill fields on measures using filters

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:

  1. The filters set on the dashboard
  2. The filters set on the tile within the dashboard
  3. The filters set on the measure that is being clicked on

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}
1 0 510
0 REPLIES 0
Top Labels in this Space
Top Solution Authors