Filter doesn't work

  • 24 May 2023
  • 1 reply

I have a panel with a report that show the number of employees that the company has by gender, and I added a Competence Date filter (date referring to payrolls) but it is not working. "Competence Date" is linked to the "Payroll" dataset, which in turn is linked to the "Employees" dataset. How can I make this filter work?


Best answer by Joseph Heun 24 May 2023, 16:20

View original

1 reply

Userlevel 3

It sounds like you need to use a BY Clause to aggregate the data appropriately. The following is an older article which explains the concept of explicit lifting to connect the datasets. Please note that the images are outdated, but the modeling and MAQL principles are the same: