Question

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

  • 9 August 2019
  • 2 replies
  • 1855 views

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.

Reply