Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 3 dimensions: Name, Title and Score; and their table boxes.
I want to write an expression for my chart as: the average of all scores of all the names whose Title is the current selected one.
How do i do that in set analysis?
ok now i under stand
if fairly simple set analysis
avg({<Name=,Title=P(Title)>}Score) will bring back the desired result
hey maybe i didn't quite understood your problem
those your dimension in the same table
in that case why do you need set analysis ,when the user select a title
the function avg(Score) will return the avg of all scores of names with the selected title
if you want the avg of all names scores you can go with avg(aggr(avg(Score),Name))
hope it helps you
Hello,
Thank you for your reply. I think i could not express myself clearly.
Indeed what i want to do is , when user selects a name (lets say the name is Liron and his title is manager)
I want to calculate the avarage score of all the other names that belongs to the manager title.
avg(score) returns only the avarage score of Liron over other dimentions.
I couldnt figure out what avg(aggr(avg(Score),Name)) does, but it also do the calculation only over Liron.
Thanks.
ok now i under stand
if fairly simple set analysis
avg({<Name=,Title=P(Title)>}Score) will bring back the desired result
yes that works! Thank you very much!!