Hello, i am new to this, but have experienve with powerapps and google sheets. I have a dataset and to simplify it looks like this:
UserEmail | ManagerEmail |
aaad | 111 |
aaa | 222 |
aaa | 222 |
bbb | 222 |
bbb | 222 |
I need to filter the slice so it only shows distinct UserEmails belonging to 222
in this case
aaa
bbb
I find this easier in SQL than in appsheets.
FILTER gives me similar results
User | Count |
---|---|
43 | |
25 | |
23 | |
14 | |
13 |