So, I want to get the average salary without the salary of the manager. My expression looks like this:
avg({<job=-{'manager'}>} salary)
But when I use this expression I cannot filter further in the app itself. Like for example, I want to get the average salaray of the male workers. It doesn't work.
When I do it like this, I can filter:
avg(salary)
But then, the default isn't without the manager's salary.
Can you help me?
