Good morning everyone,
I'm using SAS Visual Analytics and unfortunately, I can't figure out how to perform a certain operation. Let me describe the situation in general terms:
I have a report with two sections: Section 1 and Section 2.
Section 1 contains two graphs, Graph 1 and Graph 2, while Section 2 contains a crosstab. All objects are based on the same data source.
The two graphs differ only in the assigned Category field (in one case it's A, in the other it's B).
Graph 1 filters Graph 2 through an action, and Graph 2 contains a link to the crosstab.
In view mode, when I follow the link, the crosstab only receives the selection made on Graph 2, but not the one made on Graph 1 (even though Graph 1 correctly filtered Graph 2).
In edit mode, the filter from Graph 1 to Graph 2 doesn't work (an error appears: "Unable to find a column referenced by the query") — however, if I double-click on the bar that appears below the error message, I'm correctly redirected to the desired section with all filters applied, including the selection from Graph 1.
If I add Category A as a hidden data element in Graph 2, everything works correctly, but the initial display of Graph 2 changes — and I'd prefer to keep it unchanged.
How can I fix this?
I have another report that appears to be identical, where everything seems to work without needing hidden elements — but perhaps I’ve missed some detail that allows it to function correctly.
I tried to recreate the issue you described and I could not generate the same results. Open a case on Visual Analytics with Tech Support and we can probably solve this quickly with a Teams meeting.
Good morning Keith and thanks for the quick reply, I will do as you suggested, thanks again
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.