Skip to main content
Solved

Filter data which are not dimension

  • August 10, 2022
  • 2 replies
  • 383 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

2 replies

Nathan
Employee
Forum|alt.badge.img+12
  • Employee
  • 227 replies
  • Answer
  • August 10, 2022

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
  • 26 replies
  • August 10, 2022

Merci Nathan :) it’s working!