Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all.
I have a dashboard that shows activity for team members.
A person can belong to more than one team.
Activity is displayed for one team only (the team list box has Always One Selected Value checked).
I need to list the other teams that a user belongs to in a text box, excluding the currently selected team.
Example:
Bob has activity for TeamA and TeamB.
User selects Bob and TeamA.
Bob’s TeamA activity is displayed.
I now need to alert the User to the fact that Bob also has activity for TeamB.
The following lists all teams that Bob belongs to (including TeamA):
Dimension: Team
Expression: =count({<Team=>}Activity)
How can I exclude the current Team selection (TeamA) from the above expression?
Thanks in advance, Michael.
If it is only possible to select only 1 team value at the time you could use GetFieldSelections ...
And when using in a set analysis:
Team -= {$(variable)}
try
count( {<Team= e(Team) >} Activity)
Hope this helps,
Stefan
Perfect – thanks for your help!