topic Re: Range Slider Date Help in SAS Visual Analytics

Range Slider Date Help

mjaitly — Fri, 21 Nov 2014 07:30:13 GMT

Is there any way the range slider date control can get automatically refreshed. We update data daily for the previous day. So supposed I view my report today, I have to manually click on the range slider (the small clock icon) and choose the rigth hand side date as 20th Nov. I save the report. When tomorrow I login, again I have to choose the right hand side clock date as 21st Nov. I want this to happen automatically. In other words as soon as the data is refreshed and I log into the report I should see the end date (meaning the right hand side clock date) as 21st Nov, instead of having to manually choose it.

Thanks

Manish

Re: Range Slider Date Help

learn_sas — Tue, 02 Dec 2014 19:41:24 GMT

Hi Manish,

I wish there is a better solution than the one I have. If you a dummy record which has a future date then your problem will be solved. For example in the dummy record you can leave the date at say 31 Dec 2015. Please make sure you do not end up in any data quality issues.

Thanks.

Re: Range Slider Date Help

PeterWijers — Fri, 05 Dec 2014 06:09:34 GMT

Hi Manish/Arun,

Same problem for me, that any selection object can not be defaulted and stays on its selection after saving.

Beginning this year I already requested this functionality that it should be possible to default a button or range slider with a variable or like in 7.1 parameter.

So that the default selection of a buttonbar could be linked to a formula like "month of today", resulting to a default being always the current month.

This way you might be able to default the date slider selection to a start/end date being like "today +/- 5 days".

Here another request to development......

greetings Peter

Re: Range Slider Date Help

Allan_dk — Mon, 08 Dec 2014 13:16:51 GMT

There was a similar discussion earlier. But no good solution.

And remember, when you have multiple sections in a report, the user have to adjust the period on every section. The user will often miss this, and instead get the wrong information form the report.

Re: Range Slider Date Help

MichaelDalton — Sat, 13 Dec 2014 04:08:57 GMT

Is this not a similar issue with filters full stop. We are currently running 6.4 and looking to upgrade to 7.1.

We are fortunate that our processes are annual. But currently it seems like when you have a filter for year say, you are forced to set a default year on the basis of what you have selected at the last time of saving the report during designing phase.

Then when you do an upload of new years data you need go through each report and increment to the next year. It is annoying for us to do a few times a year but I imagine for others it would very very annoying on a daily basis.

I am hoping I have overlooked something but have searched and not found anything helpful.

Would love to hear of an suggestions.

Michael

Re: Range Slider Date Help

pascalschmidt — Fri, 27 Jan 2017 13:40:34 GMT

As an administrator I have access to the by SAS provided report "Administrator Overview" (table "AUDIT_VISUAL_ANALYTICS"). In the second section is a slider that has always the newest date selected. When the data is refreshed overnight the new day is automatically selected in the slider.

I've tried to find out, how SAS managed this issue in this report but I couldn't find any setting, filter or the like. Maybe there is a way to copy this report or only the specific slider and use it for own reports. Does anybody has a clue how SAS managed to always have the newest day selected?

Re: Range Slider Date Help

kundus — Tue, 11 Apr 2017 13:11:22 GMT

From SAS Analytics Designer you can’t make slider with “autosize”. There is, however, an unsupported and undocumented way to view the report’s Business Intelligence Report Definition XML (BIRD XML), so that you can change some settings in a report. From SAS Visual Analytics Designer, open the report in Edit mode and ensure the body of the report is the active window by clicking inside a report object. Then click Ctrl + Alt + b to bring up the reports’ BIRD XML.

In find bar first put label of slider, here it is called „Suwak 1” and this way we get its ref=”pr611”.

Then you search reference „pr611”and in <NumericRange> bracket you change max=”20914.0” to max=”30914.0”. Button "Load" will create a new raport with changes in XML. You need to save it.

And voila.

Re: Range Slider Date Help

pascalschmidt — Wed, 26 Apr 2017 05:56:43 GMT

Works for me! Thank you very much!

Re: Range Slider Date Help

Jadwiga — Tue, 23 May 2017 08:51:48 GMT

Fantastic! Do you btw. also know how to change the starting date to be always ex. 30 days ago?