topic Re: Link a chart using only certain filters in SAS Visual Analytics

Link a chart using only certain filters

SimonJ — Fri, 24 Feb 2017 09:56:43 GMT

I have chart that i filter by month, chart display by division lattice column and int type on the x axis if i link the to another chart/section all the filter attributes are transferred being the month, the division and the interest type. I would like to view the second chart only using the later two filters so being able to view the secon chart by month is this possible?

Thanks

Simon

Re: Link a chart using only certain filters

Frank_Boekamp — Tue, 28 Feb 2017 14:47:21 GMT

Hi Simon,

Only solution we have found for this challenge is by duplicating the dataset, base your second object on that dataset and create a (mapping) link without the date variable ( link only on the division and type)

Cheers, Frank

Re: Link a chart using only certain filters

SimonJ — Tue, 28 Feb 2017 14:52:36 GMT

Thanks frank i will try it out

Re: Link a chart using only certain filters

ShivamKS — Wed, 01 Mar 2017 08:36:52 GMT

Use filter expression on the line chart instead of interactions to filter it by a selected month. Then you can use interactions to view the second chart on the basis of your selection. In this way there will be no interaction between your month filter and the second chart.

Re: Link a chart using only certain filters

Frank_Boekamp — Wed, 01 Mar 2017 08:56:07 GMT

Hi Shivam,

If you are using reports in SAS VA your solution will only work for report designers. Report viewers are not able to create a filter expression.

Cheers, Frank

Re: Link a chart using only certain filters

ShivamKS — Wed, 01 Mar 2017 09:11:46 GMT

Hi Frank

But you can use Controls to let the report viewers select a month on which they want to filter the line chart and use parameters to dynamically capture the user selection and create a filter expression on the line chart to filter it by the selected month.

The end users(report viewer) do not have to cretae the filter expression it will be done in the designer.

Regards

Re: Link a chart using only certain filters

Frank_Boekamp — Wed, 01 Mar 2017 09:18:49 GMT

Using parameters is indeed another way to go. It's rather complex for most users to use parameters in my experience. Duplicating a dataset is a lot easier I think but also not an ideal solution.

Re: Link a chart using only certain filters

SimonJ — Fri, 03 Mar 2017 16:13:20 GMT

Hi Apoloigies for not responding earlier, i don't belive i am as experinced i am not to clear on what i have to do? But it certainly sounds like somthing that i could use, if you could explain in a bit more detail what i would need to do?

Thanks

Simon

Re: Link a chart using only certain filters

ShivamKS — Mon, 06 Mar 2017 08:34:34 GMT

Yes it is a bit complex but here is how you can do that:

You can create a parameter from the month item assigned in your control and then use that date parameter value to filter the first chart.

(please check following link on how to use parameters with date: https://communities.sas.com/t5/SAS-Communities-Library/Date-parameters-in-SAS-Visual-Analytics/ta-p/233338)

Once you have the parameter Use the Filters tab to create the follwing filter :

And then you can set up simple interaction between the first and the second chart.

So there is no derived interaction between the month control and the second chart and it is only filtered by the values passed from the first chart.

Regards