It has always been a challenge for me to compare metrics over time in an efficient manner. For example, MoM, YoY, WoW, etc. I am typically relegated to multiple dashboard widgets or ugly looking reports.
I love the ability in Ad Hoc Analysis to create 'Derived Metrics' and am excited for this capability to come to Reports & Analytics. It would be really nice to be able to create segments and derived metrics based on dynamic time values.
For example. If I am looking at last months visits (a complete month), I might want to compare MoM or YoY Metrics in table. It would be nice to create the following Derived Metric