topic How to set default date value for a report using SAS VA Report Designer in SAS Visual Analytics

How to set default date value for a report using SAS VA Report Designer

Sujata — Wed, 18 Oct 2017 12:41:49 GMT

I have designed a report using SAS VA in which we are passing dates via list box with multiple choice option enabled.
But for this list box by default I want to pass only latest date value. It seems there is no any option available to set default value.
Can somebody please help me out with same.

Re: How to set default date value for a report using SAS VA Report Designer

ali_jooan — Thu, 19 Oct 2017 06:05:01 GMT

create a numeric field for this date something like TreatAs ..

and then use it in a rank and select top 1 or bottom 1 according to your requirement ..

Re: How to set default date value for a report using SAS VA Report Designer

itchyeyeballs — Thu, 19 Oct 2017 21:28:41 GMT

Not sure if it helps but we had a similar issue with drop downs (rather than list box) with dates.

We ended up creating an extra column in data prep where newest date was shown as 'latest' rather than the actual date (we made it a text field), we then selected that in the report and saved so that 'latest' was always the default selected option

Re: How to set default date value for a report using SAS VA Report Designer

Fredrik_Hansson — Mon, 05 Mar 2018 11:17:01 GMT

I recommend using the slider (I run VA in swedish, so I'm not sure it's called "slider"). It can be used for picking a range of dates or a single date. You can make it default to the maximum value (most recent date) in data.

It includes a descent date-picker, so you actually don't have to use the slider-tool. That helps a lot when you have a long time-range to choose from.

Re: How to set default date value for a report using SAS VA Report Designer

don_data — Mon, 05 Mar 2018 21:01:15 GMT

You may be able to leverage the LAST function.