topic Time slider with dynamic range for last 2 months in SAS Visual Analytics

Time slider with dynamic range for last 2 months

abhilashatiwari — Tue, 21 Jun 2016 07:39:34 GMT

Hi All,

I have a time slider in report. Can it be set to last 2 months dynamically?

Each day when report is open, the time slider should have range of last 3 months including the current date.

Any help or suggestions on this?

Thanks in advance!

Regards,

Abhi

Re: Time slider with dynamic range for last 2 months

MelCar — Wed, 29 Jun 2016 18:45:18 GMT

How often do you update the data in the report? Is it daily, weekly or monthly?

Melanie

Re: Time slider with dynamic range for last 2 months

abhilashatiwari — Thu, 30 Jun 2016 08:16:41 GMT

Hi Melanie,

The data for most of the reports refreshes daily.

Regards,

Abhi

Re: Time slider with dynamic range for last 2 months

MelCar — Thu, 30 Jun 2016 16:00:05 GMT

Here is one way to do it.

Create a new calculate item that will convert your date into a number so you can use it to rank by:

Add a name (I used Numerical Date), drag and drop the TreatAs operator under Numeric (advanced) to the Visual Pane and add your Date category (make sure the drop down in the TreatAs equation is set to _Number_).

Click the OK button.

Next we need to change the properties for this new measure. From the Left Pane, select the Data tab. Then select your new measure (in this case I selected Numerical Date). Update the Aggregation to Average and the Format to Numeric.

Add a Slider control to the section. On the Roles tab select your date field for the Measure/Date.

Next, we need to duplicate our Date category so that we can use it to rank on. From the Left pane select the Data tab and then select your Date category. Right click and choose Duplicate Data Item.

You can then rename it or just leave it as is.

Click back onto your Slider and then click the Rank tab.

Select your new Date category from the drop down then click the Add Rank button. Next, select Top Count from the drop down then make sure the radio button is selected next to Count. Then enter 90 in the box (this will give you the last 90 days). For the By: select your Numberical Date measure.

Now only the last 90 days will be available in the slider.

Next, link your slider to any charts you have on the section that you want to filter the date on.

Then you are done.

I hope this helps.

Melanie

Re: Time slider with dynamic range for last 2 months

abhilashatiwari — Wed, 06 Jul 2016 14:16:18 GMT

Hi Melanie,

Thank you so much. Very well explained, and so easy to follow the steps. Yes it does solve the purpose.

This is exactly what Iw as looking for.

Thanks!!

Regards,

Abhi

Re: Time slider with dynamic range for last 2 months

MelCar — Wed, 06 Jul 2016 23:08:52 GMT

so glad it work out!

Re: Time slider with dynamic range for last 2 months

abhilashatiwari — Thu, 07 Jul 2016 08:01:33 GMT

Hi Melanie,

Is it also possible to keep the history in the date slider with the dynamic range for 1month.

For example in image below:

Type A: It has all the dates with only one month of range selected, which should be dynamicaly updated everyday.

Type B: It shows only 1 month of dynamic date range.

It would be great to have the complete date range, so that user by default see one moth of data, but do have the option to go to previous dates.

Thanks!

Regards,

Abhi

Re: Time slider with dynamic range for last 2 months

MelCar — Fri, 15 Jul 2016 17:35:21 GMT

I don't believe that would be possible. If I come up with something I'll let you know.

Melanie

Re: Time slider with dynamic range for last 2 months

abhilashatiwari — Thu, 04 Aug 2016 08:39:41 GMT

Thanks Melanie!

Re: Time slider with dynamic range for last 2 months

Jadwiga — Wed, 26 Apr 2017 08:39:58 GMT

It does not seem to update the selection, only the dates that are available on the slider...

Re: Time slider with dynamic range for last 2 months

MelCar — Wed, 26 Apr 2017 15:03:51 GMT

Is the slider linked to the other charts?

Re: Time slider with dynamic range for last 2 months

Jadwiga — Tue, 02 May 2017 08:40:37 GMT

The slider is in the Report Header. It looks like on the attached picture. The slider shows rolling 60 months but I would like to always SELECT last 6 months

Re: Time slider with dynamic range for last 2 months

PatrickPosthuma — Tue, 09 May 2017 08:12:54 GMT

Hi Abhi,

This what you described is exactly what I need.

Do you (or others) already know the solution for it?

Thanks in advance!

Re: Time slider with dynamic range for last 2 months

VictorM — Thu, 31 May 2018 09:41:21 GMT

Hello everyone,

Im using SAS VA 7.4 and even though I follow exactly the steps above mentioned by Melanie, I am not observing the same behaviour.

I create a numerical date, called "Date Num"

I then changed "DateNum" to "Numeric" and "Average"

I then created a slider with "Date" as role :

And finally applied the rank on a duplicated "Date(1)" field, COunt 30, by "DateNum" :

As you can see, the slider will consider the last 10 days? from May 19 to May 28 (and not last 30)

Plus, my slider minimal date should be Nov 2017, as you can see when the rank is disabled :

What did I miss ?

thanks

Victor

Re: Time slider with dynamic range for last 2 months

MelCar — Fri, 01 Jun 2018 15:54:05 GMT

When you use ranking it pre-filters the data so you will only see the last 30 days in your slider. As to it only showing the last ten days... can you move the slider to include all 30 days then save the report? I believe the next time you or someone else opens the report it will include all 30 days in the filter.

I think I understand what you are trying to accomplish. With 7.4 there might be other features we could use to make this easier. I'll look into it and get back to you.

Melanie

Re: Time slider with dynamic range for last 2 months

MelCar — Fri, 01 Jun 2018 18:57:54 GMT

Here is another way of doing this that allows you to filter the results for a rolling 30 days from the last date you choose.

From the Data panel, right click on your Date field (mine was called Date) and select Create Parameter from Data Item.

Name it Date Parameter and click ok.

Now we’ll add a couple of calculated Items. The first one will hold the ending date.

From the Data Pane, select the Options icon, then click New Calculated Item.

Name the new calculated item end date num. Click on the Text tab and cut and paste the following text:

TreatAs(_Number_, DatePart('Date Parameter'p))

Note: my Date field was a DateTime value so I had to add the DatePart function. If your field is a just a date value then you don’t need the DatePart. Your text should read TreatAs(_Number_, 'Date Parameter'p)

Click Ok.

Select end date num and set the Aggregation to Average.

Now we’ll create a new calculated item for the beginning date (30 days prior to our end date).

Using the Options menu again, select New Calculated Item. Enter beg date num for the name. Click on the Text tab and copy and paste the following text: TreatAs(_Number_, DatePart('Date Parameter'p)) – 29.

Remember: If your date field is not a datetime format you will need to remove the DatePart. Your text should read this: TreatAs(_Number_, 'Date Parameter'p) – 29.

Click Ok.

Set the aggregation to Average for beg date num.

Add a slider to your report and select the Properties tab and choose Single for the value.

Under roles choose your Date field as the Measure/Date and choose Date Parameter as your Parameter.

Click Yes when the following pop-up message appears.

Add a chart that you want to filter your data by the last 30 days for. Set up your roles for what you want to display. In my case I added a time series line chart that is displaying Oxygen levels in water.

Select the filters tab for your chart. Click Add Filter, click on the Text tab and copy and paste the following text.

( TreatAs(_Number_, DatePart('Date'n)) BetweenInclusive('beg date num'n, 'end date num'n) )

NOTE: if your Date field is not DateTime format you will need to remove the DatePart. Also, your date field name maybe different from mine. So, you’ll have to change Date to the name of your date field. Your text should read this: ( TreatAs(_Number_, 'Date'n) BetweenInclusive('beg date num'n, 'end date num'n) )

Your chart should now show a rolling 30 days depending on the date shown in the slider.

Hope this helps!

Melanie

Re: Time slider with dynamic range for last 2 months

SKG — Wed, 30 Jan 2019 06:09:18 GMT

Hi Victor, Sorry for late reply. Actually I faced the same issue. Try to do this way, it will work.

1) Create calculated Item

2) Change format:-

3) select the filed "Year" and right click on it and select Category option

4) Select slider object and then click the Rank tab

5) Select "Year" then Click on "Add Rank" button then choose "Top Count" from the drop down then make sure the radio button is selected as "Count". Then enter 10, 20, 50 and so on in the box (respectively this will give you the last 10 years, 20 years, 50 years and so on). And "By:" option select Registration_Date and Include "Ties".

6) After that, you can select min and max date only for one time and from the next day it will automatically selected max date as per data.

Regards,

Sunny

Re: Time slider with dynamic range for last 2 months

angeldbracho — Thu, 14 Feb 2019 13:12:11 GMT

Hi guys,

hope you are well. I'm having a little trouble with SAS VA 7.4, I'd be glad if you could help me.

I have data from two years: 2017 and 2018 (I'm interested in a numerical variable). I put a slider (period) that's filtered, to show only 2018 values.

I want to make a bar chart, that shows, for a category, the cumulative amount for the selected period in the slider (no problem with that) but also the cumulative amount for the same month in the previous year.

The blue bars are ok but not the Green ones (cumulative period of the same month, previous year). I'm trying with the aggregated measure "cumulative period" set for previous year (-1) but it doesn't work, and don't know why, although it worked well when using it in a cross table with "period" as columns.

Can you help me?

Thanks and regards!!