Skip to main content
Solved

Filter data which are not dimension

  • Aug 10, 2022 2:21 PM UTC
  • 2 replies
  • 688 views

Forum|alt.badge.img+6

Hello guys, 

 

I want to filter a metrics according to items which are not dimensions - how is it possible? 

Indeed the yellow part below is not working as Alma_fees_eur is not a dimensions but is a defined as a number. Thanks a lot! 

 

Best answer by Nathan

Hi Alix,

you need to do the FILTER before the BY.
BY aggregates the data so you are not at the transaction level anymore

View original

2 replies

Nathan
Employee
Forum|alt.badge.img+12
  • Employee
  • Answer
  • Aug 10, 2022 2:24 PM UTC

Hi Alix,

you need to do the FILTER before the BY.
BY aggregates the data so you are not at the transaction level anymore


Forum|alt.badge.img+6
  • Author
  • Wallflower
  • Aug 10, 2022 2:48 PM UTC

Merci Nathan :) it’s working!