It would be great if we could compare dates (WoW, YoY, etc.) in Analysis Workspace. Almost every person at my company who uses Analysis Workspace have asked for it.
We very much appreciate the feedback, @viclin. (Also great to hear that so many people at your company are using Analysis Workspace.) This is something we definitely want to do; ease of comparison should be one of the core benefits of Analysis Workspace. I don't have an ETA, but our engineers are actively working on definining how this should work and getting it done.
So glad to see your update on this, Ben! I'm looking for this feature too. I would be able to replace a lot of manual reporting with Analysis Workspace if I could do YoY, MoM, WoW. Keep us updated! Thanks.
Agree with @viclin, would be awesome to have this feature and be able to compare YoY, MoM, etc, side by side in a table/chart, like what we can do in Key Metrics reports like Visits and see Current Month, 4 Weeks Prior and 52 Weeks Prior, but with more flexibility.
Just another vote for this, as it's been the primary blocker in migrating business users/reports into Analysis Workspace.
My preferred approach for this is to allow for rolling date ranges to be applied in Segments, so that a "Last Year" or "Last Week" segment could be created and either directly applied to a column in Analysis Workspace, or applied to a "Last Week Average-Visits" calculated metric. That flexibility would be ideal.
The closest thing that AW has to this feature right now is by:
1 - set your dates to expand from the beginning of the first date comparison to the end of the second date. (for example, if you're comparing December to January, set your date to December 1-January 31.
2 - Pull in the metric you want to compare. In our example, use Month as your dimension rather than using the default: Day
3 - Use the built-in Time dimensions to "segment" each metric. (For example, pull the "Month" Time dimension above or below the metric in your report).
Ouilah! You know have date comparison! Obviously it's not as flexible as a true date comparison via the Calendar module, but it's a step in the right direction. Note that you can use the other built-in Time dimensions like Day, Year, etc and you can also create your own! Just open the Segment Manager, drag in one of the Time dimensions, and adjust to your needs.
Also want to add, that these should be in a way that I should be able to plot them on a line graph as seperate lines, so to see the trends of this year v/s last year at a day granularity.
- the custom date feature that is currently in place, does not sort by time range. So if I add '2 weeks ago, 3 weeks ago, Today, Yesterday', mycustomdaterange' in the rows, and Visits in the column, it will sort alphanumerically. I want to be able to say Today, Yesterday, mycustomdaterange, 2 weeks ago, 3 weeks ago, etc.
