Can anybody Please explain how do I create a Quarterly and Monthly view of the same data.
I want to create a parameter where the end user gives the input whether he wants to view the data Quarterly or Monthly
and the view changes according to that.
Hi,
I will try to show concept with screens:
1. Add Supporting Table, then create button-bar and declare connected parameter ("Par_PERIOD", text type)
2. In Fact Table (witch contains data to be analysed) create new calculated category ['Date' is calendar date]:
3. Result: one report with several views (measures and categories from Fact Table Source):
Best Regards
Robert R.
You could potentially levearge the Stack Container to allow the report viewer to choose between which visualziation they want to see (Quarterly or Monthly). Robert Anderson has a great write up on stacked containers in his post: Using Containers in SAS Visual Analytics.
Hi I did it in my report, it’s not so complicated 😉
Same technic I'm using for reviewing data in daily, weekly, monthly or yearly perspective, as well as for viewing results for period or cumulated in the same report.
Hope it's clear, forgive me poor English.
Robert R.
@RR2809 this is a great tip. I think I am slowly understanding the concept. I think you have a drop down list wherein you can select from-
Monthly (781)
Quarterly (45)
My numbers are dummy but the actual table will probably show the record count. Now can I implement a similar thing for multiple selecction? Say the users can select more than 1 categorical field from -
Country (2)
Market (12)
Product (5)
Region (21)
Please feel free to send me a private message if necessary
Thanks,
saspert.
Hi,
I will try to show concept with screens:
1. Add Supporting Table, then create button-bar and declare connected parameter ("Par_PERIOD", text type)
2. In Fact Table (witch contains data to be analysed) create new calculated category ['Date' is calendar date]:
3. Result: one report with several views (measures and categories from Fact Table Source):
Best Regards
Robert R.
Thanks a lot. It was really helpful.
Another thing I would like to ask is :
If we have to create a text parameter, everytime we'll be making excel tables like the one you mentioned in your post?
Megha.
Hi,
No, you need excel file only once - just to prepare supporting data source in repository.
Of course you can prepare this table in Guide or other way .... Whatever.
In report, then:
Create button-bar, assign cattegory, right click mouse - choose "Create parameter"
Robert R.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.