Analysis Workspace: Compare dates

@EricBricier: Thanks for the comment, Eric. We agree, and we're working on delivering this functionality soon. I'll make no secret about that.

Hi @benjamingaines

I 100% agree with @MonicaS & all other answers here. This one will allow us to migrate a lot of manual / RB dashboards/reports into Workspace and key to a wide adoption in the company on top of all the other benefits we have with Workspace.

At the moment, we can work around this by duplicating Panels (one for this year, one for last year) or creating custom date ranges for YoY comparison. It's ok for aggregated comparison over a time range. However, we're used to trended graphs in our RB dashboards with This Year and Last Year lines on the same graph for an easy, quickly eye-catching comparison and this is the #1 thing I can't really do in Workspace at the moment.

Eric

To echo @viclin 's point - this is also a stumbling block for wider adoption of AW within my company. Operating in a seasonal industry, YoY, WoW, YTD, FYTD comparisons are essential to our reports. 

Having to export AW reports into Excel to achieve this, negates the the tools flexibility and feels like a glaring omission given the more advanced mathematical functions it offers. 

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

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. 

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

Source image file 21097 not available

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

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!

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.

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