Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Show latest in drop down in SAS VA??

Reply
New Contributor
Posts: 3

Show latest in drop down in SAS VA??

I have a drop down with dates. The data is updated every month, so new dates appears all the time.

My question is if it is possible to get the drop down menu to choose the "newest" date automatically when the report is updated with new data?

Occasional Contributor
Posts: 12

Re: Show latest in drop down in SAS VA??

Hi All,

 

I have the same query.Can someone throw some light on this.Also, Is there a way to set a recent date as a default selection for a line chart.

 

Thanks

Aswin Rahul

SAS Super FREQ
Posts: 274

Re: Show latest in drop down in SAS VA??

Hello Aswin,

Unfortunately, I don't believe this is possible in the current release.

You can suggest this feature for a future release by going here:
https://communities.sas.com/t5/SASware-Ballot-Ideas/idb-p/sas_ideas/label-name/sas%20visual%20analyt...

And then click "New Idea" to submit your feature request.

Thanks,
Sam
Occasional Contributor
Posts: 12

Re: Show latest in drop down in SAS VA??

Thank you Sam.I appreciate it.I will suggest this for a feature request. 

Regular Contributor
Posts: 172

Re: Show latest in drop down in SAS VA??

Daniel,

I have a solution using parameters to let a Date dropdown always start with the current date.

Selecting  a history button, the ather dates get selectable.

You can make any version of this, so not be tied down to this example.

If this would get close to your question, I can provide you with the solution set-up

selection.png

 

 

Greetings Peter

Occasional Contributor EWS
Occasional Contributor
Posts: 19

Re: Show latest in drop down in SAS VA??

Hello Peter,

 

This solution looks very interesting to me so if you can share this with us it would be highly appricated.

Regular Contributor
Posts: 172

Re: Show latest in drop down in SAS VA??

At first I created a key selection table in LASR to be able to create the button selection.

So for this purpose there are two values (Today,History)

Using a separate table guarantees no intervention problems with the original data table.

 

While selecting the button the value is being transferred to the linked Parameter  (Lets call it Period.Sel)

 

On the Date DropDownList now add the next filter

 

IF ( 'Period.Sel.'p = 'Today' )
RETURN ( 'DATE'n = DatePart(Now()) )
ELSE ( 'DATE'n < DatePart(Now()) )

 

Anyway sort the dropdownlist descending by date, so even with History the last date will show on top of the list.

 

This should do the job.

 

Greetings and good luck.

Peter

 

Occasional Contributor EWS
Occasional Contributor
Posts: 19

Re: Show latest in drop down in SAS VA??

Thanks for sharing!

Erwin
Occasional Contributor
Posts: 12

Re: Show latest in drop down in SAS VA??

Thanks Peter !!
Post a Question
Discussion Stats
  • 8 replies
  • 1218 views
  • 9 likes
  • 5 in conversation