BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
JPinkman
Calcite | Level 5

Hi,

I am working on a dashboard (report) that has 2 dropdown filters on the canvas, in order to define an interaction between them. One contains the Year category, the other one organisational structure . Reason is that in 2013 the organisational structure differs form that in 2014. I got this working.

Now I want to define interactions between the 2 drop downs with charts in the reports. I manage to add the interactions, but somehow the mapping settings of both drop downs seem to interact. The end result is that both interactions have the same mapping for either year or sector, resulting in one disfunctional dropdown filter. Both dropdown filters are based on the same data source.

Has anyone experienced this also? Is my construction not feasible? Is there another way?

Many thanks..

PS: using sas va 6.4m

1 ACCEPTED SOLUTION

Accepted Solutions
MichelleHomes
Meteorite | Level 14

Hi,

Thanks for the screenshot. I am wondering if it may be the order in which you have set up the interactions. In the explanation above you said that you had initially set up both drop downs with separate interactions to 10 eerste onderzoeken and because of that when you filter from dropdown 9 it isn't subsetting dropdown 10. Perhaps you could delete the 3 interactions and set up the following:

1) filter interaction from dropdown 9 to dropdown 10

2) filter interaction from dropdown 10 to 10 eerste onderzoeken - when you do this a derived interaction (dotted line) should appear from dropdown9 to 10 eerste onderzoeken, if the derived interaction checkbox is marked. The derived interaction is due to the filter flow from dropdown 9 also affecting the chart. As such a direct filter interaction would not be needed from dropdown 9 to 10 eerste onderzoeken.

Hope this helps.

Cheers,

Michelle

//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com

View solution in original post

5 REPLIES 5
MichelleHomes
Meteorite | Level 14

Hi,

Would it be possible for you to take a screenshot of your Interaction View screen so that we can get a better understanding of the issue? From the right pane, select the Interactions tab and click on the Interaction View button or use the View -> Show Interactions menu item.

Can you please confirm your statement "The end result is that both interactions have the same mapping for either year or sector"... you mean when you select year or organisational structure the filter is not happening or that it is and if so, what is the filter being passed to the chart (click on the chart object and the funnel icon on the tab - this will tell you what is being filtered).

I haven't experienced this before and your construction sounds feasible - hard to say without seeing it though. Assuming, the data is loaded appropriately in the table for filtering, it could simply be that your interactions need to be set up correctly.

Kind Regards,

Michelle

//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com
JPinkman
Calcite | Level 5

Hi Michelle,

see below:

interactionview.png

What I meant by The end result is that both interactions have the same mapping for either year or sector".

Is that I initially set up both drop downs with separate interactions to 10 eerste onderzoeken, dropdown 9 with a mapping for year category, dropdown10 with sector category mapping (which are the visible values in respective drop downs).

After some testing I notice the interaction works for the year category . But when I also click on dropdown10 to filter sectors, the whole thing gets confused: I notice that drop down 9 is not filtering 10 eerste onderzoeken anymore. When opening the mapping of the interaction I see it's now same as the mapping from drop down10, namely sector category.

Hope this clarifies some!

THanks!

MichelleHomes
Meteorite | Level 14

Hi,

Thanks for the screenshot. I am wondering if it may be the order in which you have set up the interactions. In the explanation above you said that you had initially set up both drop downs with separate interactions to 10 eerste onderzoeken and because of that when you filter from dropdown 9 it isn't subsetting dropdown 10. Perhaps you could delete the 3 interactions and set up the following:

1) filter interaction from dropdown 9 to dropdown 10

2) filter interaction from dropdown 10 to 10 eerste onderzoeken - when you do this a derived interaction (dotted line) should appear from dropdown9 to 10 eerste onderzoeken, if the derived interaction checkbox is marked. The derived interaction is due to the filter flow from dropdown 9 also affecting the chart. As such a direct filter interaction would not be needed from dropdown 9 to 10 eerste onderzoeken.

Hope this helps.

Cheers,

Michelle

//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com
JPinkman
Calcite | Level 5

Hi,

I had come to the same conclusion myself already: choose the right year in dropdown(dd) 9. This filters dd10. FIlter the chart with the sector of choice from dd10. This also filters the data for the the year of choice in dd9 indirectly.

Thanks again! Cheers

MichelleHomes
Meteorite | Level 14

Hi,

It seems that the issue is now resolved? If so, please mark the question as answered so that the community knows.

Thanks,

Michelle

//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 5 replies
  • 1217 views
  • 0 likes
  • 2 in conversation