Analysis Workspace: Compare dates

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.

Please continue to add comments and votes here! 

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.

@FeFinotto: Thanks for commenting! This continues to be one of our top priorities for Analysis Workspace. 

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.

Looking forward to all the product updates!

Source image file 21097 not available

Again - not ideal, but a step in the right direction

@jake_winter: Good to know that this is preventing widespread adoption. It's one of our top priorities on our product backlog. Stay tuned.

Another vote for the YOY, MOM, WOW date ranges. 

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. 

@MonicaS: Thanks for commenting and voting! We're committed to getting this done.