Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a chart with 5 expression lines and my company owner wants to be able to choose the one(s) he wants to see at any given time.
I built a selection box and used conditional enabling in the chart to show the ones requested by the selector but apparently it's not that simple. If I select one, hooray! I get the one I want. If I select more than one, I get an error message saying all expressions are disabled.
And because I know it's helpful and someone will ask (), I am attaching the view. Can anyone please point me in the right direction?
Thank you!
You have used
if(vsel_chart_typ='a',...
that will not work. vsel_chart_typ will return empty string when more that 1 value is possible
use something like below
SubStringCount(Concat(vsel_chart_typ,'|'),'a')
as the condition
please note you have a and ab there that may cause issues. i suggest giving full names in the vsel_chart_typ dimension
like Abandoned and use above substring count method
You have used
if(vsel_chart_typ='a',...
that will not work. vsel_chart_typ will return empty string when more that 1 value is possible
use something like below
SubStringCount(Concat(vsel_chart_typ,'|'),'a')
as the condition
please note you have a and ab there that may cause issues. i suggest giving full names in the vsel_chart_typ dimension
like Abandoned and use above substring count method
Thank you ever so much! I just switched abandoned from 'ab' to 'b' in the script and it worked like a charm!
I am very appreciative of your assistance!