'filter_expression:' is not supported for measures of non-aggregate type 'number'

  • 9 August 2019
  • 2 replies

Userlevel 7
Badge +1

I have a Custom Measure based on a measure type numbers that’s a division of this kind:

${TABLE}.sessions / ${TABLE}.days_in_month

Now, in one particular look I want to only get this measure based on a specific day of the week so I’m using the aforementioned measure + following filter: ${date_day_of_week_index} = 1

Somehow I’m getting an error that number is not supported for filters… Any reason why is that?

I already have an idea on a workaround (pivot by day of week + table calculations) but this would be much easier, wouldn’t it?

2 replies

Userlevel 7
Badge +1

And the circle of life has been completed again.. Need to be able to filter MIN(date) so much!

Hi @Dawid , not sure if this helps at all but what helped me was applying filter to the individual measures that make up your final measure. There’s an explanation on it here.