Different Reference Lines based on Expression

[#1]

First post in the community
I have a difficult question.

I'm making a chart that shows Volumes, Hours and Productivity for a certain Process. These expressions are grouped in one chart via Cyclic group. They all have different Targets and I want to show these Targets via a horizontal line, but when I add a expression for the Target, it will show the line in all the different cyclic expressions. I also tried it in the reference line option but I cant figure it out.

Is there a solution that i can show a target line based on the expression the user is seeing?

Please help,

Jasper

[swuehl · Accepted solution]

Jasper,

I don't know any method to retrieve the current expression from an expression group.

Maybe you can work around using conditional expressions instead of an expression group. See attached sample.

[#3]

Great!!!

I've looked at your example file and the second solution with the inputbox works for me.

One small question though.

How do i remove the dots in the inputbox?

[swuehl]

Have you cleared the 'Label' for the variable in general tab of the input box?

[#5]

Nope

Thnx got it.