So, it looks like this ruined the top line total for percentages (rates, not percentage of total) - there's no longer the option to average, just sum or "Grand Total" so if I have 2 segments in my table and CTR as a metric column, the total is either CTR 1 + CTR 2 or total CTR based on the entire available dataset. I want the average CTR of the segments in the table.

There are differences in data availability between the tools and unless that's resolvable, Data Warehouse will never be an acceptable solution to this problem.

Long term, you could add an eVar that captures the week of the year as a numeric value. That will take a couple years to become useful though.Short term, there is a manual workaround..If you create date ranges for each week of this year and last year, you can then create a segment for each week of the year.Then use that in your table with your metrics filtered by "this year" and "last year."The percent change metric is based on the year, but the segment filters the totals to just the applicable ...

Yay!! Do you have an estimated ETA?

I also want to be able to order them manually! I have tables using metrics as rows and alphabetical order does nothing for me in that scenario.