Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Link a chart using only certain filters

Reply
Occasional Contributor
Posts: 7

Link a chart using only certain filters

Hi

 

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

Contributor
Posts: 52

Re: Link a chart using only certain filters

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

Occasional Contributor
Posts: 7

Re: Link a chart using only certain filters

Thanks frank i will try it out

Occasional Contributor
Posts: 14

Re: Link a chart using only certain filters

Hi

 

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.

 

Contributor
Posts: 52

Re: Link a chart using only certain filters

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

Occasional Contributor
Posts: 14

Re: Link a chart using only certain filters

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

Contributor
Posts: 52

Re: Link a chart using only certain filters

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.

Occasional Contributor
Posts: 7

Re: Link a chart using only certain filters

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

Occasional Contributor
Posts: 14

Re: Link a chart using only certain filters

Hi

 

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/...)

 

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

 

Filter expr.PNG

 

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

 

Interactions.PNG

 

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

Post a Question
Discussion Stats
  • 8 replies
  • 177 views
  • 1 like
  • 3 in conversation