BookmarkSubscribeRSS Feed
Anand6666
Calcite | Level 5

I had been creating and testing out reports on SAS VA as part of VA certification and happened to find a tutorial on filtering a graph based on user input.

I created a simple barchart with a min and max value to be read as user input. I created 2 parameters which was assigned to text input object and later an advanced filter was applied on the barchart based on the value entered in the text input field but the user inputs doesn't seem to have the desired effect on the barchart.I am attaching a screenshot for better understanding. Kindly advise what could i be doing wrong.

SAS VA V7.4 Hotfix 06

1 REPLY 1
FredrikE
Rhodochrosite | Level 12

Look like quantity is aggregated in the graph.

Your parameters might work but what they do is that they keep ROWS in the raw data between 1 and 40000.

These rows are then aggregated in the graph, showing greater values than 40000.

 

I think you can overcome this by creating an aggregated measure and then use this in the graph 🙂

//Fredrik

SAS INNOVATE 2024

Innovate_SAS_Blue.png

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. 

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
  • 1 reply
  • 511 views
  • 0 likes
  • 2 in conversation