BookmarkSubscribeRSS Feed
MClay
Fluorite | Level 6

Hello,

 

I'm wondering if it's possible to make a graph's axes and layout static so that the shell of the graph stays the same but that data can change if you apply report or page filters. For example, I have a bar graph with lattice columns A, B, C, & D. If I apply a report (or page) filter that doesn't have data for lattice B, that entire lattice column is removed from the table and I only see lattices A, C, and D. I'd like to keep the lattice column (and rest of the graph) the same but display it as empty (or 0%). 

 

I have tried building a custom graph but the lattices still disappear when I apply a filter. I have also tried adding dummy filler lines to my data set but this didn't work either. Any other ideas? Is there a setting for this maybe?

 

Thanks!

3 REPLIES 3
Sam_SAS
SAS Employee
Hello MClay,

I don't think there is an easy option to get what you want to do here.

When you tried adding dummy rows to your data, did you leave missing values, or did you insert values of zero? Adding zeroes should work, but it might have undesired effects (it might change averages, for example.)

Sam
MClay
Fluorite | Level 6

Hi Sam_SAS - thank you for responding!

 

I did add 0s to the dummy lines of data but this does indeed inflate a calculation in the graph. However, even with those 0s, VA doesn't display the lattice column because it is 0s across the board for the entire section of responses for the variable. 

 

I tried creating a parameter and linking it to a filter with all 4 of the lattices selected, then testing the report filter but this did not keep the graph axes fixed. Do you have any ideas for a workaround? 

 

Best,

Mona 

Sam_SAS
SAS Employee
I don't have any other ideas, but maybe someone else will.

Meanwhile, please go here:
https://communities.sas.com/t5/SASware-Ballot-Ideas/idb-p/sas_ideas/label-name/sas%20visual%20analyt...

and create a feature request ('idea') so that the development team is aware you'd like to have this feature.

Thanks,
Sam

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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
  • 3 replies
  • 668 views
  • 0 likes
  • 2 in conversation