Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Filtering users in a group

Savio
New Member

Hello! I have an app with some users and i created a custom filter in it:

Explanation: Data field its meant to user enter the DATE, while SVC means USER
Then, the data is filtered on the next 2 dashboards.

Im using a table with update only, with quick edit to let users select what they want on filter

When i click on SVC (users), shows a dropdown like that:

The filter its working fine, when i click “Todos” (show all), it shows all users.

My question: How can i GROUP users? In the picture above, theres CO, MG1, MG3… these are meant to be groups.

Example: CO will have User1, User2 and User3

The individual filter is working, but how can i group it using the formula below?

Formula im using to FILTER:

IF( ANY(Filtro[SVC] )="Todos", [Data]=ANY(filtro[Data]),
AND([Data]=ANY(filtro[Data] ),
[Usuário]= ANY(Filtro[SVC] ))
)

The formula above its working as intended, showing individuals SVC (users), and all of them with Todos (show all). I just want to add to it the option to group up users in one option.

I can add more information if needed.

Thanks!

0 7 577
7 REPLIES 7
Top Labels in this Space