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?
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.
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.
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?
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 :
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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.