4 Replies Latest reply: Jan 10, 2012 7:25 AM by duygucakmak

# Set expression of all the values with a given dimension

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?

• ###### Set expression of all the values with a given dimension

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

• ###### Set expression of all the values with a given dimension

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.

• ###### Set expression of all the values with a given dimension

ok now i under stand

if fairly simple set analysis

avg({<Name=,Title=P(Title)>}Score) will bring back the desired result

• ###### Set expression of all the values with a given dimension

yes that works! Thank you very much!!