topic Re: current week's worth in SAS Visual Analytics

current week's worth

jplarios — Fri, 05 Feb 2016 16:14:05 GMT

It seems an easy task but I can't fugure it out; I want to filter a report from Now() to Now()-7 ; basically the current week's worth of data.

Assuming data in memory with a date and date time available to use.

Can anyone help me on this?

Re: current week's worth

Explore_SAS — Fri, 05 Feb 2016 16:18:09 GMT

you can use filter tab on the right hand side of your report desinger to filter the data you want to see in the report.

Re: current week's worth

jplarios — Fri, 05 Feb 2016 16:23:02 GMT

but would that be relative to a week or hard coding some dates?

Re: current week's worth

Explore_SAS — Fri, 05 Feb 2016 16:25:25 GMT

I guess, it would be hardcoding for some dates.

Re: current week's worth

Explore_SAS — Fri, 05 Feb 2016 16:27:36 GMT

or else you can add a slider as filter on your report and assign date category to it.

Re: current week's worth

jplarios — Fri, 05 Feb 2016 16:31:02 GMT

thanks; I was looking foor som preiodic type function; so when the report is refreshed , it only refreshes for the current week; assuming I only have a date and date time available in memory - i.e not having to go back to ETL.

Re: current week's worth

Explore_SAS — Fri, 05 Feb 2016 16:33:33 GMT

There is option of function of relative period when you calculate aggregated column, if you want to aggregate something for a relative period, please check if its useful for you.

Re: current week's worth

Sam_SAS — Fri, 05 Feb 2016 18:10:53 GMT

@Explore_SAS wrote:
There is option of function of relative period when you calculate aggregated column, if you want to aggregate something for a relative period, please check if its useful for you.

RelativePeriod operator does not work at the week level, unfortunately.

Re: current week's worth

Explore_SAS — Fri, 05 Feb 2016 19:40:17 GMT

Hey sam do you know, how the option of _Inferred_ for grouping period it says that it takes the grouping based on data in the report but it never worked for me.

Re: current week's worth

Sam_SAS — Fri, 05 Feb 2016 20:03:57 GMT

@Explore_SAS wrote:
Hey sam do you know, how the option of _Inferred_ for grouping period it says that it takes the grouping based on data in the report but it never worked for me.

An issue with _Inferred_ is that it will often use an inferred interval period of "day" for the inner interval but the LASR function does not like to process "day" and so the operator returns missing values in most cases.

If your date data item has a format like MMMYYYY, then _Inferred_ should correctly set the inner interval to "Month".

Personally I always set the interval parameters to the period I want rather than using _Inferred_.

Eventually this should work better than it does right now.

Re: current week's worth

Explore_SAS — Fri, 05 Feb 2016 20:56:43 GMT

The problem with us is that, we have to calculate the difference with between relative date like what is change of value from yesterday to today. by default VA doesn't have option to choose interval as day. so we have to rely on _inferred_ assuming that VA with automatically understood looking at the data.

Re: current week's worth

Sam_SAS — Fri, 05 Feb 2016 21:21:58 GMT

The periodic operators do not handle relative dates correctly when the interval is day. Possibly some day processing was supported in earlier releases but it could return bad results. The operators were changed to always return missing values when the interval is day and there is any offset processing to do. I don't remember whether day processing was enabled in any customer-facing release.

Day interval is still fine for operators like Period that do not calculate a difference between dates.

Re: current week's worth

PeterWijers — Sat, 06 Feb 2016 15:23:30 GMT

Answer to your first question is this code used in the filter.

It wil filter out your data for the last 7 days.

If you need the running week then you need a sligtly different code.

Greetings Peter

Re: current week's worth

Jun_KP — Wed, 07 Mar 2018 21:20:49 GMT

Hi Peter,

Thanks for the filter. I am interested to know how to filter out the running current week instead of the last 7 days. Do you mind share the text code for filtering out the current week?

Thanks!

Jun

Re: current week's worth

Sam_SAS — Thu, 08 Mar 2018 13:30:02 GMT

Possibly you could leverage the DayOfWeek() operator to filter out the days where DayOfWeek(Date) is less than DayOfWeek(DatePart(Now()))

Re: current week's worth

PeterWijers — Fri, 09 Mar 2018 06:50:15 GMT

Please try this one.

Works for me. Not sure if you want to use the function to filter from today on.

Greetings

Re: current week's worth

Jun_KP — Fri, 09 Mar 2018 16:47:58 GMT

Thank you both Sam and Peter for your inputs! I worked it out based on your inspiration of utilizing both DayOfWeek and WeekNumber functions. Here's the filter for displaying current week of the year:

( Datepart (Date)>= First Day of Current Year ) AND

( ( Datepart(Date)>= Datepart(Now())) OR ( DayOfWeek(Date) <= DayOfWeek(DatePart(Now())) ) ) AND

( WeekNumber(DatePart(Date)) = WeekNumber(DatePart(Now())) )

Jun

Re: current week's worth

Sam_SAS — Fri, 09 Mar 2018 18:20:48 GMT

Great! Glad to help 🙂