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 now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
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.