Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a line chart with the following dimensions / expression:
Dimension 1
Year
Dimension 2
=if(Aggr(Max(Ranking_lower),Institution)>=vMinRank and Aggr(Min(Ranking_lower),Institution)<=vMaxRank,Institution)
Expression
if(Indicator='Overall',Ranking_lower*(-1),
if(Indicator='Academic reputation',[Academic Reputation Rank_lower]*(-1),
if(Indicator='Employer reputation',[Employer Reputation Rank_lower]*(-1),
if(Indicator='Student-to-faculty ratio',[Faculty Student Rank_lower]*(-1),
if(Indicator='Citations per faculty',[Citations per Faculty Rank_lower]*(-1),
if(Indicator='International faculty ratio',[International Faculty Rank_lower]*(-1),
if(Indicator='International student ratio',[International Students Rank_lower]*(-1),
Ranking_lower*(-1)
)
)
)
)
)
)
)
If I click on an institution within the Institution list box, the chart only shows only that institution, but what I want is to highlight (use a color for the institution selected, and make all other other unselected institutions grey), I tried to wrap the expression like this, but it doesn't do anything. If I click on an Institution in the list box, it stills only shows that particular institution on the chart and hide everything else:
sum({<Institution=>}
if(Indicator='Overall',Ranking_lower*(-1),
if(Indicator='Academic reputation',[Academic Reputation Rank_lower]*(-1),
if(Indicator='Employer reputation',[Employer Reputation Rank_lower]*(-1),
if(Indicator='Student-to-faculty ratio',[Faculty Student Rank_lower]*(-1),
if(Indicator='Citations per faculty',[Citations per Faculty Rank_lower]*(-1),
if(Indicator='International faculty ratio',[International Faculty Rank_lower]*(-1),
if(Indicator='International student ratio',[International Students Rank_lower]*(-1),
Ranking_lower*(-1)
)
)
)
)
)
)
)
)
Any advise on how I can make this work?
Hi,
Try to use range expression like below , 1 will used to ignore the selection.
Dimension2;
=aggr(sum({1<Ranking_lower = {">=$(vMinRank) <=$(vMaxRank)"}>}Ranking_lower),Institution)
appreciate if you can share app.
Hope this helps you
Regards,
Deva