User Problem

Users want to be able to change their query aggregation dynamically based on the length of time selected in an attached Calendar control. For example, it would be helpful for the aggregation to change from day to week when 30 or more days are selected or week to month when 90 or more days are selected. 

Suggested Solutions

Add an additional aggregation option "Dynamic" that allows the user to select an associated {CALENDAR} control. This would then programmatically select an aggregation interval that makes sense based on the range of the input. This range size could be calculated prior to creation of the query and based on the length, programmatically provide the query with an aggregation based on the length of the {CALENDAR} selection.

Suggested predetermined ranges could be:

1-3 days: Hour
3-29 days: Day
30-89 days: Week
90-364 days: Month
365-1094 days: Quarter
1095+ days: Year

These sample ranges are determined by having the next larger interval have at least 3-4 rows based on the size of the aggregation. 

Current Workarounds

Currently, this sort of dynamic behavior does not appear to be possible.