Filter a report based on the user table by group

Max Nowak
Kilo Sage

‎02-04-2022 11:05 AM

Hi,

I built a simple report that lists all users that fit a certain criteria, and put that report on a dashboard. I'd like to be able to filter the users by group, so for example, if I select "group A" in a filter, I only need to see users that are members of group A, and so on.

I tried to play around with interactive filters, but I'm unsure how to configure them (or if it's even possible) for my requirement. I created a reference field interactive filter, but it doesn't seem to work that way, since users and groups don't directly reference each other, but with the m2m table.

Any kind of help would be appreciated.

0 Helpfuls
  • 1,150 Views
1 REPLY 1

Saurav11
Kilo Patron
Kilo Patron

‎02-04-2022 11:11 AM

Hello

You can create the report on sys_user_grmember

And then create the interactive filter it should work

Please mark answer correct/helpful based on impact

0 Helpfuls