08-27-2015 06:17 PM
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?
09-09-2015 04:55 AM
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.
09-11-2015 12:36 PM - edited 09-11-2015 12:40 PM