DOMO Groups filter

Hi DOMO Team -
Good Day!
I just need some help with regard to groups.
we created a list of new groups for all our people
and created a card to show all the groups that they are in and it shows that including the new group that we put them in.
we would like to create a Beastmode where, when this person is in their 'legacy' groups and is also in the 'new' group, then they get filtered out.
but if they are only in their 'legacy' groups, then they stay in the card.
Here is an example>>>
the New Group S includes Saitama and Flashy Flash
We want to exclude Saitama who is in New Group S
and those that show Saitama in Group A and Group B
and also exclude Flashy Flash who is also in New Group S and Flashy Flash Group A
We only want to show Mumen Rider left on the list, since he is not included in New Group S
Basically, if you are in New Group S, you need to be excluded from the list, along with all the other 'you' that shows on other Groups
but if you are not in New Group S, you stay on the list.
Thanks!
Comments
-
I am thinking of doing a group by in dataflow
where in when they are in Group S then the other groups will be greater than 1.
so, anything that is greater than 1 means that they are in a group.
if they are not in Group S is 0.
but I can't seem to make it work.
0
Categories
- 10.5K All Categories
- 7 Connect
- 917 Connectors
- 250 Workbench
- 466 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 193 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 173 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive