Question

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

  • 9 August 2019
  • 1 reply
  • 1668 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?


1 reply

Userlevel 7
Badge +1

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

Reply