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.
... View more