in VA 7.3 I'm looking at a table of web session data where each row is indicated by a session date, a unique session ID, and a dummy (1,0) variable called clicks (See also attached screenshot). I would like to create a line chart where for each day the percent of change from the previous day for the number of clicks (in my case the sum of clicks) is displayed.
I have experimented with the Aggregated Measures feature in Explorer (i.e., the RelativePeriod Periodic operator), but when I create such an aggregated measure and use the line plot visualization, I get only missing values. So, I'm not sure if it is possible using periodic operators for daily values. The User's Guide documentation lists conditions under which that operator returns missing values:
Note: Periodic operators return a missing value in the following scenarios:
Data does not exist for the specified time period.
The date data item for the period calculation does not match the date data item in the visualization or report object. You must use the same date data item or a duplicate data item that is based on the same data item.
The interval for the operator is smaller than the interval of the date format in the visualization or report object (for example, if your interval is by month, but the date format is Year).
For operators that use inner and outer intervals, the inner interval is larger than the outer interval.
The inferred interval is by week of the year or by an interval smaller than a day.
The inferred interval is by day for any operator that has an offset other than 0.
Is there a workaround solution to use calculated items or aggregated measures to get what I want? Or am I doing something wrong and misinterpret the documentation?
Thanks in advance for any insides or suggestions
BTW, if you need to reproduce the simulated data from the screenshot, you may use this SAS code and then upload the resulting SAS table to LASR:
do session_id=1 to 10000;
if ranuni(1)>0.9 then click=1; else click=0;
format session_date date9.;
proc sort data=tmp; by session_date;run;
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.