Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have a question regarding the target lines. Is it possible to have the target lines stagnant?
I have a combo chart with 2 dimensions and 1 expression. Additionally I have 5 more expressions which would depict the 5 target lines. (The line doesn't show when I use "Reference Lines", hence I use expressions).
Is it possible to have the target lines that doesn't change with selections? For eg., when I have NO selections made I have the Chart1. And when I make a selection in a particular field I end up with Chart2. But the expected chart when I make a selection should have the same target line as in Chart1 and the bars as in Chart2. Is this possible? If yes, How?
Chart1:
Chart2:
Add {1} to the expression for the line so that it ignores all selections. For example if that expression is sum(Target) change it to sum({1}Target).
Add {1} to the expression for the line so that it ignores all selections. For example if that expression is sum(Target) change it to sum({1}Target).
Works perfectly for me, Thank you very much.