BookmarkSubscribeRSS Feed
jplarios
Quartz | Level 8

Hello:

A user selects by some drop down value A or value B - where the drop down is a parameter. A or B are column names in the data. I have a visual , for example a line chart, such that the horizontal axis will change between A or B based on the user selection. is this possible? if so, if column A or B are dates. I know parameters currently don't support date values; I would like to pass column name value , a character named A, such that in the line chart's category-role-assignment of A, is a date format.

My goal is: I have 3 types of x-axis values and would like to have only one trend visual where the user selects the type of x-axis. Similar to the designer view where I can right click on the x-axis and replace the column - except I need a similar functionality on the report.

Thanks for any help.

3 REPLIES 3
SAS_Mike
Obsidian | Level 7

Hello,

I have a couple of clarifying questions:

1.  When you state your goal is to be able to replace the column, do you mean replace the category that has been assigned to the category section of the chart with a different category?

2.  Are all three data types you would like to switch between dates, or are some dates and some numeric values?

Thanks

jplarios
Quartz | Level 8

hi SAS_Mike,

1. Yes, the category, but in the data , the categories , A and B, are columns named as such but date formats.

2. Yes, some are numeric and one date.

SAS_Mike
Obsidian | Level 7

Hi jplarios,

My initial thought is that you could use a calculated item and use an if statement based on text or numeric choices in a drop down list.  I was trying to test this, but I think I need an example of how you have the data organized in your file to make sure I am using similar information.  Could you post a quick example of the table of you are importing into SAS?

Thanks

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
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
  • 1350 views
  • 0 likes
  • 2 in conversation