topic Re: Filtering Line on a combo chart based on variables in App Development

Filtering Line on a combo chart based on variables

CrysiiD_BI — Tue, 30 Nov 2021 16:25:32 GMT

I have a combo chart (bar & line). The bars change based on the variable selection I have. I also want the lines to change but it seems difficult to accomplish. The line represents a goal, when I switch the variable to yes I want a certain goal to display and when I switch it to no I want another goal to display. I'm not sure how to go about this. I can't go the flag method as the goals are not fixed, I use set analysis to calculate the goal.

Is this even possible? If not do you have any alternatives? I was thinking about adding an alternative line on the chart and it seem viable for one sheet, but on the next sheet we have 5 charts. It would be tedious to have the user switch to the alternative on each chart. Hopefully I am explaining this well.

Any help I can receive is much appreciated.

Re: Filtering Line on a combo chart based on variables

rubenmarin — Sat, 20 Nov 2021 09:23:22 GMT

Hi, maybe with a combniation of pick and match to show the expression you want, like:

Pick(Match('$(varName)','Yes','No') ,[ExpressionForYes] ,[ExpressionForNo] )

So if the variable stores 'Yes', Match() returns '1', and Pick uses the 1st expression. If the variable stores No, Match() returns 2 and Pick goes to the 2nd expression.

Re: Filtering Line on a combo chart based on variables

CrysiiD_BI — Tue, 30 Nov 2021 14:08:08 GMT

That worked! Thank you!!!!