Please see diagram enclosed. It groups all dates individually from min to max.
cast([min_lock_date],varchar(10))+' '+cast([max_lock_date1],varchar(10)) this formula produces the minimum date and max date of the lock date. I want this data item to select the min and max based on one week intervals instead of just one min and max date. The aggregate function does not allow me to summarize based on another data item so how would I accomplish this in a weekly grouping
You probably want to include a _week_of_year calculation in your query.