BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
DirkHorsten
Calcite | Level 5

In a Visual Analytics report in SAS VIYA 3.5, I have a drop down box to select the date for which to show the data.

By default, I want to show the current situation, i.e. the last date present in the data.

In the settings for a drop down box, there is an "Initially select first item" check box, but no option to initially select the last, nor an option to sort in reverse order.

The solution suggested in different forums is to change the sort order of the data item used in the drop down in the in data pane. However that only works with so called "categorical" variables and SAS VA does not see dates as categorical variables.

Does anyone know a workaround?

For completeness: a picture in the data pane, date variables are shown with a calendar icon (In this case the date is calculated from a time stamp. That is why there is a calculator in the icon too.) Categorical variables are shown with a tree legged symbol. The context menu for categorical variables has a Custom sort option. That for dates not.

DirkHorsten_1-1664958992313.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
KeithM
SAS Employee

Don't click on the three dots.  Right mouse click in the body of the drop down.  Where the X is in my screen capture.

KeithM_0-1664982606552.png

 

View solution in original post

3 REPLIES 3
KeithM
SAS Employee

I have a date data item and I can sort on it in a drop down list. 

KeithM_0-1664979343943.png

 

When I right mouse click on the drop down list, I get the following:

KeithM_1-1664979443949.png

 

 

 

DirkHorsten
Calcite | Level 5

Thanks KeithM, but this does not work, probably because we are running a different version of SAS VIYA.

 

84   %put _automatic_;
AUTOMATIC AFDSID 0
...
AUTOMATIC SYSVER V.03.05 
AUTOMATIC SYSVLONG V.03.05M0P111119
AUTOMATIC SYSVLONG4 V.03.05M0P11112019
...

 

For me, clicking the right mouse button on the dots left of the drop down box gives

DirkHorsten_0-1664981203974.png

I have the impression you put your dropdown box in the page controls. I put it on the page itself, because it should not filter the whole page.
So I just tried putting a similar drop down in the page controls, but that did not resolve the issue.

KeithM
SAS Employee

Don't click on the three dots.  Right mouse click in the body of the drop down.  Where the X is in my screen capture.

KeithM_0-1664982606552.png

 

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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
  • 750 views
  • 0 likes
  • 2 in conversation