topic Re: Time slider with dynamic selection for last month in SAS Visual Analytics

Time slider with dynamic selection for last month

PatrickPosthuma — Tue, 09 May 2017 08:29:06 GMT

Hi All,

Is it possible to dynamically set the date for last month in a slider

Today 09-05-2017

Tomorow:

How to set the range dynamically is already described in the post beneath.

However I want to keep the full range and select per default the last month.

https://communities.sas.com/t5/SAS-Visual-Analytics/Time-slider-with-dynamic-range-for-last-2-months/td-p/278933

Re: Time slider with dynamic selection for last month

bpazzaglini — Tue, 09 May 2017 09:29:38 GMT

You can use the classification on the slider. You can create a support variable for the month and use that on the classification chosing the first two occurnce.

Paz

Re: Time slider with dynamic selection for last month

PatrickPosthuma — Tue, 09 May 2017 11:00:18 GMT

Hi Paz,

Sorry I did not get you,please explain.
What do you mean with classification?
To be clear the first/default selection must be from 09-04-2017 till 09-05-2017
Tomorow it should be from 10-04-2017 till 10-05-2017
It must be possible to select manually a wider range.

Re: Time slider with dynamic selection for last month

bpazzaglini — Tue, 09 May 2017 12:14:33 GMT

If you select an object on the report builder on the right side you have a panel in wich you have different section (Role, propertiety, classificatio, filter, ...)

On the classification you can choose for exaple the first ten value on a certain variable.

In your case you can set a filter (not a classification) for example

today() -30 < <your_ data_variable> < today()

You should find the filter thet more suite for you situation

Paz

Re: Time slider with dynamic selection for last month

PatrickPosthuma — Tue, 09 May 2017 12:33:43 GMT

Hi Paz,
For a slider there is no classification tab and a filter works on the range, not on the 'default/initial' selection

Re: Time slider with dynamic selection for last month

bpazzaglini — Tue, 09 May 2017 13:04:12 GMT

Ranks not classification. I'm used with the italian version, sorry.

I belive the this can help you Check this

I've done a test and it works

Paz

Re: Time slider with dynamic selection for last month

PatrickPosthuma — Tue, 09 May 2017 14:07:13 GMT

Hi Paz,

That is the link I already refer to when I start this post.

This solution changes the range not the actual selection

Re: Time slider with dynamic selection for last month

PatrickPosthuma — Fri, 12 May 2017 10:54:21 GMT

Anybody a solution for my requirement?

Re: Time slider with dynamic selection for last month

Renato_sas — Tue, 16 May 2017 14:51:56 GMT

Hi @PatrickPosthuma,

This capability has been added to the latest release of VA running on the SAS 9 platform, VA 7.4. There are options now that allow for setting the slider range values to dynamic minimum and dynamic maximum, which would do exactly what you want. I'm not aware of any workarounds for releases prior to 7.4.

Best,

Renato

Re: Time slider with dynamic selection for last month

ilsescheys — Tue, 14 Nov 2017 20:20:11 GMT

Hello @Renato_sas

I need this also.

Can you give me more details on how I should do this ? I need the last 6 months to be selected. I will set the maximum value dynamic. So that solves the upper limit. But I can't get to set the lower limit correctly.

Thank you in advance.

Re: Time slider with dynamic selection for last month

ilsescheys — Wed, 15 Nov 2017 09:34:56 GMT

Hello @PatrickPosthuma
How did you solve this ?
Did you use the dynamic minimum/maximum?
Thank you

Re: Time slider with dynamic selection for last month

PatrickPosthuma — Wed, 15 Nov 2017 10:21:54 GMT

Hi @Renato_sas according to me this is still not possible in version 7.4, please set this topic als not solved yet.

Re: Time slider with dynamic selection for last month

PatrickPosthuma — Wed, 15 Nov 2017 10:22:40 GMT

according to me this is still not possible in version 7.4 😞

Re: Time slider with dynamic selection for last month

AnnaBrown — Wed, 15 Nov 2017 14:13:25 GMT

Hi @PatrickPosthuma,

Thanks for the info! We are looking into your problem a bit more closely. In the meantime, I've "unmarked" the response from @Renato_sas as the solution.

Best,

Anna

Re: Time slider with dynamic selection for last month

HunterT_SAS — Wed, 15 Nov 2017 15:18:39 GMT

I think there is some confusion in this thread about what the problem is that I'd like to try and clarify. And of course if I've misunderstood then please correct me.

First, it IS possible in Visual Analytics 7.4 to set a dynamic start and end point for range sliders so that whenever you open the report, the start and end points are the first and last dates in your data, respectively. This is what Renato is referring to.

I don't believe this is what Patrick is getting at though. Rather, it sounds like Patrick wants the range slider to automatically be set so the start and end point is the first and last date of the last month in the date range. So if my full range is January to November, I want the selected range to automatically be November 1st (the first date of the last month) to November 15th (the last date of the last month), while maintaining the earliest possible starting point as January 1st in the slider.

This is currently not possible.

The closest you could get is to set the end point to be dynamic (not the start point) and then manually adjusting the start point each time the month changes.

Alternatively, you could have a drop down list or something else for Month that filters the range slider, then use the dynamic start/end points in the range slider. So if you pick November in the drop down list, the range slider is automatically filtered for the first and last dates in the November range. I don't know if that makes sense for what you're doing though. And of course it still requires a user to do something to get the date ranges to what you want, as opposed to being purely automatic.

Re: Time slider with dynamic selection for last month

Renato_sas — Wed, 15 Nov 2017 21:46:24 GMT

I apologize everyone for the confusion. I guess I've misinterpreted the original request, or at least part of it, and provided a partial answer. What @HunterT_SAS has just replied is absolutely correct. Again, my apologies for the confusion.

Re: Time slider with dynamic selection for last month

PatrickPosthuma — Wed, 15 Nov 2017 22:18:38 GMT

Hi @HunterT_SAS,

Thanks for your answer, I think you understand what I want.

Unfortunately it is apparently not possible yet.

The desire change should be the possibility to use two variables "start selection and end selection".

Example

TIme slider is from 1 jan 2015 till 1 jan 2020, but it should select per default the last month

calculated field 1 = Today() = 15 november 2017

calculate filed 2 = today() - 1 month. 15 oktober 2017

(Current date 15 november 2017)

1 jan 2015-------------------------------slider------------------------------------------------------1 jan 2020

15 oktober 2017------dynamic selection--------15 november 2017

Where can I post a change request? 😉

Re: Time slider with dynamic selection for last month

PatrickPosthuma — Wed, 15 Nov 2017 22:19:58 GMT

No problem!

Re: Time slider with dynamic selection for last month

AnnaBrown — Thu, 16 Nov 2017 16:12:34 GMT

Me again, @PatrickPosthuma! Feel free to submit a product idea in the SASWare Ballot ideas section of the communities.

Anna

Re: Time slider with dynamic selection for last month

PatrickPosthuma — Wed, 22 Nov 2017 09:29:31 GMT

Posted the idea:

https://communities.sas.com/t5/SASware-Ballot-Ideas/Time-slider-with-dynamic-selection-for-last-month/idi-p/415428