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.
... View more