Analysis Workspace: Compare dates

Avatar

Avatar

psvlin

Avatar

psvlin

psvlin

03-12-2015

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.

33 Comments (33 New)
33 Comments

Avatar

Avatar

benjamingaines2

Avatar

benjamingaines2

benjamingaines2

03-12-2015

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! 

Avatar

Avatar

michelleg997808

Avatar

michelleg997808

michelleg997808

14-12-2015

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.

Avatar

Avatar

fvisani

Avatar

fvisani

fvisani

26-01-2016

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.

Avatar

Avatar

benjamingaines2

Avatar

benjamingaines2

benjamingaines2

27-01-2016

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

Avatar

Avatar

jakewinterbb

Avatar

jakewinterbb

jakewinterbb

18-02-2016

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.

Avatar

Avatar

eric_matisoff

Avatar

eric_matisoff

eric_matisoff

21-02-2016

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!

Avatar

Avatar

eric_matisoff

Avatar

eric_matisoff

eric_matisoff

21-02-2016

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

Avatar

Avatar

benjamingaines2

Avatar

benjamingaines2

benjamingaines2

25-02-2016

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

Avatar

Avatar

monicas9

Avatar

monicas9

monicas9

14-04-2016

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. 

Avatar

Avatar

benjamingaines2

Avatar

benjamingaines2

benjamingaines2

14-04-2016

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