Is there any way to filter dates, but allow the full range of dates only for aggregated measures?
For example, I want to create a geo region bubble map, with a value, let's say inquiries, as the size for a selected month. I also want the color to be based on change from previous year (using an aggregated value) for a different metric, let's say sales. So if a user selects January 2015, I want the map to be sized by inquiries for January 2015, and colored by % change in sales from January 2014 to January 2015. The problem I run into, is when I use a filter on the map to select January 2015, it filters out January 2014, and the aggregated measure comes up with no value. Does anybody know a workaround for this?
Thanks.
I'm not aware of a way - I have learned to do things where I didn't have to use a filter. For instance, I built the aggregated measure using the Periodic Operators under the Aggregated Measure.
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.
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.