Dynamic reference lines for bar chart based only on the filter pane

[mukesh19]

Hi all,

I have a bar chart, table and filterpane. I want to add the reference line for the bar chart in such a way that the reference line should be based on the filterpane, if no selection is done the reference line should show the complete value, If selection is done it should show only value related to that selection.  The important criteria is reference should not change  based on the other selections except the filterpane.

thanks,

mukesh

[agigliotti]

what fields do you have on your filterpane ?

[mukesh19]

subject

[agigliotti · Accepted solution]

in your measure expression you should use a set analysis to ignore all selections except for the subject field.

ex. sum( {1< subject = $::subject >} your_measure_field )

[mohan_1105]

A slight Modification of Andrea expression,

sum({<subject=>} your_measure_field)

This Expression also work ...!!

[mukesh19]

The value has to be overall value instead of any selection

[mohan_1105]

That any selection includes "Subject"?

[mukesh19]

for eg.:  I have many filterpanes subject,x,y,so on...There is a bar chart with reference line. The reference lines should change the values only with respective to the selection in subject only, not with the other x,y,z so onn fileds.

[agigliotti]

did you try the expression i suggested you?

[mukesh19]

yes i tried but its not wrkng