I have the below requirement, I need to create dynamic averages example for rolling 3 months and compare with the selected month.
Example: this month is Nov'19and sales total for Nov'19 is 20 and the rolling 3 month avg (last 3 month avg) is 25.
I have created an aggregated measure for rolling 3 months avg successfully. But, I need to set the threshold in graph not in table.
For this I have taken Dual access line chart. One measure I have given Sales total and other I have given rolling 3 month Avg.
Data I have:
Prod_A_Sales Prod_B_Sales Month
5 6 Jan'19
10 15 Feb'19
20 24 Mar'19
What I need to showcase is a line chart or bar chart where bars will be product for any month. and a base ine or threshold line with Avg value.
I have used a bar line chart for this and tagged avg variable to the line. I am unable to stabilize the line straight with single value. please help how I can select _FORALL_ in the aggregated measure so that the threshold line will only show one average. like If I select Nov'19 from date filter. The product (bars) show nov totals and line will show (Aug, sep and oct avg) with st line.
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.