Detach a expression in chart

[markgraham123]

Hi All,

I'm trying to detach one expression in the line chart so that it always shows entire value, whereas other expression varies by selection.

EG:

in the attached example, when i select A, i want one expression to show all ID values but other expression to show all values so i can see trend.

[Gysbert_Wassenaar · Accepted solution]

Change the expression to sum({<ID>}Value) or sum({1}Value). To ignore selections in all fields use {1}. To ignore selections only in the field ID use {<ID>}.

[sunny_talwar]

Ignore selection in ID

Sum({<ID>} Value)

[markgraham123]

GD,

When i try the above logic, it just disappears in full value color,

Trying to separate both colors (may be making one a bit transparent..but not working)

[Anonymous]

as I see each ID has two values

do you want to see both values e.g. when you select ID = A

like this: to achieve this you can define Value as second Dimension and sum(Value) as Expression)

or you the second chart? just promote Value to first place

or how your Chart should look like?^

[markgraham123]

It worked.

Thanks

[markgraham123]

It worked.

Thanks  again sunny bro.

[markgraham123]

Thanks sir