topic SAS VA create weekly executive report in SAS Visual Analytics

SAS VA create weekly executive report

Ming80 — Fri, 28 Jan 2022 01:37:08 GMT

Hi everyone,

I am completely new to SAS VA . I some transaction operation data (50k rows in 2 years) and I would like to use SAS VA to create a executive report to create reports with graphs which show (compare) metric for each week.

Re: SAS VA create weekly executive report

Sam_SAS — Fri, 28 Jan 2022 15:03:51 GMT

You can make a stacked bar chart like the one in your screen capture:

Make a bar chart and assign a category to the Group role. Set the Grouping Style option to stack the group values, and set the Grouping Scale option to Normalize to 100%.

You can also set a Week format on your date variable to give values like 22W04. I'm not sure if there is an easy way to get weekly values labeled with the first day of the week (01/03/2022)

Let us know if that helps,

Sam

Re: SAS VA create weekly executive report

Ming80 — Sun, 30 Jan 2022 11:27:41 GMT

Hi Sam,

Thank you for your reply. I think my biggest problem now is that I don't know how to group/filter transactional data into each week.

Re: SAS VA create weekly executive report

Sam_SAS — Mon, 31 Jan 2022 16:22:58 GMT

If you are fine with the "22W01" style of weekly date values, all you need to do is assign a weekly format to your date column.

If it is a requirement to have standard date values to represent each week, AND you have VA 8.3 or later, then here is one way to do it:

You need a calculated item and an advanced filter to get this.

First we will create a calculated expression so that every row will contain the value for the entire week:

The Period() operator aggregates the values for the current time period. We need to select _ByWeek_ for the final drop-down here. If your VA is older than the 8.3 release, weekly intervals are not supported and this won't work.

So now that we have a column that has each week's total, we'll want to hide all the date values other than the day of the week we want to show. We'll use an advanced filter to do this:

You make a filter like this by opening the Filters pane and selecting New Filter... Advanced Filter.

This filter uses the DayofWeek() operator and I am selecting "2" which is Monday. So each date displayed in your chart will be a Monday.

So if you create your bar chart using the calculated item above, and you apply the filter, then you can get a result like the bar chart at the top of this post.

Let us know if that helps,

Sam