Expression legend filtering issue

[#1]

Hi everyone ,

In my chart I have one dimension and against it there are 2 expressions which are stacked over one another , when I click on legend of first expression then what I want is to show only that expression bar in chart and hide other one(as we have legends functionality when we have 2 dimensions and 1 expression), Is there any workaround to do this???

Regards:

Mubbasher

[vikasmahajan]

Select Second Dimension -> Untick -> Show Legend Option

hope this is resolve.

Vikas

[michael_maeuser]

for each expression you can add a condition:

e.g. your 2 expressions:

sum(a)

sum(b)

condition for expression a:

getselectedcount(b)=0

condition for expression b:

getselectedcount(a)=0

[#4]

Hi Michael ,

My two expresssion are

Sum(Cost)

Avg(Cost)

this chart have only 1 dimension i.e. Product

there are two legends

Red=Sum(Cost)

Green=Avg(cost)

So what I want when i click over Red legend in chart it should only show Red Bar and in legends only red legend.

[rajeshvaswani77]

Would Dimension that is a drill down group in your case help?

Looks like thats what you are looking for.

thanks,

Rajesh Vaswani

[#6]

No I only have one dimension so no need of a group dimension.

[tresesco]

You can groug the expressions too in expression tab.

[#8]

I know but in my case user should be able to view both expressions at the same time , in case if he want to view any of one then he can click over its legend to view only that expression.

[tresesco]

No direct option I can suggest you. Workaround could be like: try with three buttons(Both, Expr1, Expr2) and conditional enablement of the expressions. Could that be an option?

[#10]

That can be an option , but as in another chart I have 10 expressions , for those there will be hiding legend and positioning legends will be a problem.