BookmarkSubscribeRSS Feed
AnjaliRocks
Calcite | Level 5

In SAS VA , i want to have a drop down for Rolling like ' 1 month','3 month'

 

If 3 month is selected, my NPS data must show a sub total of scores for current month ( which is a parameter in date mmm. format) , current month -1 and current month -2. The result needs to be there in List table.

Input data :- 

Month         NPS

Jan               10000

Feb                20000

Mar                30000

Here period is in button bar and selection of month is stored in parameter. 

rolling input :-

3 months

6 months

If i selected Mar from first source and selected 3 months from rolling source , the output should be as below.

Mar 60000

 

How to achieve this in SAS VA

2 REPLIES 2
AnjaliRocks
Calcite | Level 5

Here selection of 3 months is taken from a dummy table. Kindly assist to resolve this.

AnjaliRocks
Calcite | Level 5

In SAS VA , i want to have a drop down for Rolling like ' 1 month','3 month'

 

If 3 month is selected, my NPS data must show a sub total of scores for current month ( which is a parameter in date mmm. format) , current month -1 and current month -2. The result needs to be there in List table.

Input data :- 

Month         NPS

Jan               10000

Feb                20000

Mar                30000

Here period is in button bar and selection of month is stored in parameter. 

rolling input :-

3 months

6 months

If i selected Mar from first source and selected 3 months from rolling source , the output should be as below.

Mar 60000

 

How to achieve this in SAS VA

sas-innovate-2024.png

 

Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 253 views
  • 0 likes
  • 1 in conversation