Hi, I am using SAS VA 7.1. I am trying to build a very simple crosstav report with GrossCost as the measure  and "week of" as the category. I am trying to calculate the previous weeks spend as a new measure. How do I do this? When I change the option to _inferred_ it does not work. However, if I have it as _month_, it seems to work but gives me a monthly figure. I see the below formula when I use by monthly. RelativePeriod(_Sum_, 'GrossCost'n, 'weekOf'n, _ByMonth_, -1, _Full_, {Date}) Thanks, saspert ... View more

Hi, I want to convert the following list January February March April May June to the following list - 1 2 3 4 5 6 Thanks, saspert ... View more

Hi, I have data for 6 months. I am trying to create a bar chart that shows current month vs previous month. So if I add a section prompt, the bar chart should show only 2 bars. The first month is easy. How do I create the second bar that points to the previous months data and place it adjacent to the current month? ALTERNATIVE is ok too - I have 2 date variables (week of, date aired). I have a categorical variable Month (Jan - Jul). The custom calculation I am trying to do is on a measure "actual spend". When right click and try this option on Actual spend, I choose "create" -> "% difference from the previous month" but it lets me use only the 2 date variables but not the categorical variable month. I tried creating a duplicate date variable frm the "week of" and display as month using the format options. But still the custom category would not allow me to choose the new date variable. How do I create the % difference of a measure (actual spend) at the weekly and monthly level? using any combination of the date variable (week of) and categorical variable (month)? So I tried my best to create the custom category. this is the formula I got - RelativePeriod(_Average_, 'Actual Spend'n, 'Week Of'n, _Inferred_, -1, _Full_, {Date}) ) but it  is not working correctly. for the first row, it gives a % but is . for all others. Is there a lag function in SAS VA 7.1 Thanks, saspert Message was edited by: Raj Addepalli as on 08/04/2015 Message was edited by: Raj Addepalli ... View more

Hi, I am trying to add several graphs using containers but not able to do so. I need 2 custom graphs adjacent to each other in a horizontal container. Below this container, I need 3 graphs in a stacked container. Is this possible? Because every time I add the custom graph, it does not add itself into the horizontal container. Thanks, saspert. ... View more

Hi, I have several issues regarding building and viewing custom graphs - 1. My supervisor created a custom graph and saved it in a public folder. But when I go to report designer, I am not able to open the template to be able to use it. However the "2G reports" are shareable and viewable. 2. I am trying to create a bar-line chart with 2 Y axes and X axes as time. A few issues here - a) time is at a very granular level of data - daily. I want to able to aggregate it to weekly level and have the X axes say "week of 1/1/2015 - 1/7/2015" .... b) How do I used shared roles? I need both the line graph and bar chart to have a common measure split by group (say spend and CPV by channel) c) I would need the multiple line graphs to show the break down and 1 line graph to show the total CPV. I cannot post any graphs since the size limit is 1K and my graph in zipped format is 52 KB. Thanks, saspert ... View more