Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody:
I'm trying to make calculated dimension ignoring part of the restriction of current selections.
I have data about a test. There are three teams that have passed the test. I have the name of the team members, the score they got in the test and the team they belong to.
I want to compare myself with the rest, so when I select a team in the team selector I want to compare the members of the team with me.
I have tried to make a calculated dimension in this way:
=Aggr(only({<Team={"*"}>+1<Name={'Me'}>}Name), Name)
but it doesn't work.
Can anybody help me?
Please don't create duplicate threads -> Trouble with calculated dimension ignoring selections
Please don't create duplicate threads -> Trouble with calculated dimension ignoring selections
Sorry
No worries
Hello!
Let's make things simpler.
See the attached .qvw
Moved the Only function into expressions. Put a persistent column pointing out "me" score and tweaked the graph a little to make it look better.
Obviously it can be done a lot better but it gets to the point!