charts vs sliders

[buzzy996]

hi,

if we move slider one (postcode slider), values only need to be change on "PostCode vs Sales" chart.

if we move slider two (SalesId), values only need to change on "SalesId vs Sales" chart.

any help?

thanks

[dplr-rn]

Use set analysis

Change your expression in PostCode vs Sales to 

=sum( {<SalesID=>} Sales)

basically the new addition ignores selection of SalesID

SalesID vs Sales

=sum({<PostCode=>}Sales)

ignores selection of PostCode

[buzzy996]

hi,thanks for this..looks correct but in my case i'm using

dimension as : monthname(enddate)

expression:=AVG(Date([Startdate],'DD/MM/YYYY')-Date([Enddate],'DD/MM/YYYY'))

so , how to use/place in the above expression?

[dplr-rn]

Move the dimension to the script (this is better for performance too) i.e. create a new column e.g.
monthname(enddate) as Month

[buzzy996]

if tht is the case we have to create multiple expressions for each month separately, i think tht's not a good idea!

any other help?