This title might be a little confusing, but this is what I want to do:
Some other ideas to get it to work are fine, but the main key here is that I need to see all jobs for a user, whether they are the main or secondary user.
Solved! Go to Solution.
Create an Inline view with this expression inside a virtual column in the Employees table:
FILTER(
"Jobs",
IN(
[_THISROW],
LIST(
[Main Tech],
[Secondary Tech]
)
)
)
This will add the list of jobs where the current tech was assigned, either by main or secondary technician
Create an Inline view with this expression inside a virtual column in the Employees table:
FILTER(
"Jobs",
IN(
[_THISROW],
LIST(
[Main Tech],
[Secondary Tech]
)
)
)
This will add the list of jobs where the current tech was assigned, either by main or secondary technician
I ended up going with something similar to this. Thank you!
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |