Top N reflected on other charts as well

[ninnartx]

Hi all,

I want the top N from one chart to be associated to another chart as well.

For example, if I have a bar graph and the users could input their own dimension limit using input box and a variable, I would like the result to be reflected on another chart as well.

For example, if I were to select Top 3 students for the bar chart, I would like their average score to be displayed on another chart.

Since I'm not actually making a selection and am using dimension limits to limit the Top N number, I can't figure out how to link them.

Any help would be appreciated! Thank you

[swuehl · Accepted solution]

You can't really link the charts, but you can use set analysis in your second chart to limit the field values according your first chart.

Something like

=Avg({<Student= {"=Rank(Avg(Score))<=3"}>} Score)

If you need more help, post your complete dimensions and expressions you are using in both charts.

Or upload a small sample QVW.