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!
User | Count |
---|---|
36 | |
9 | |
3 | |
3 | |
2 |