Create a proper Hour dimension for Web (Native already has it)

@jer @viclin: This should be available on November 10. Note that this will NOT give you hour as a dimension to be used anywhere. It will let you compare a specific hour against the same hour on another day. For hour as a dimensions, we continue to recommend a Time Parting solution using JavaScript. 

per a Ben Gaines suggestion a while back:

1. I have the standard time of day eVar (10:23|Friday) which I classify into different time dimensions.

2. I then create segments by hour of day and label them 00, 01, 02, 03...

3. I then drag these segments into an analysis workspace table to compare metrics.

4.  analysis workspace allows you sort segments.

this works well as a good hack.  however, everytime I change a metric, segement, or dimension in the report, the segments will resort highest to lowest. 

as an addon feature - it would be great to be able to lock the components in a table so they do not resort when you change a comparison component.

sweet! thanks!  daily/hourly dashboards/workpaces will improve considerably!

In Ad Hoc, I can select Hour/Day/Month as a dimension but they are always stored as the exact calendar date. If I want to compare the months of two calendar years against each other, it would be useful to have a dimension that only stores the month. That way I can build tables with year in the columns and month in the rows directly in Ad Hoc. For the same reason, having hour and day in the same format woulf be useful.

Agreed 100%, @michael-jet. We'll be removing the date so that comparison is possible. 

@benjamingaines awesome! This will add a lot more value to Workspace!

First of All - Analysis Workspace is terrific!! Keep up the good work!

I am having a hard time finding how to compare two time periods by hour of day.  I see there is an 'hour' dimension.  However, this dimension includes the date.  This makes it hard to compare two diffrent time periods (i.e. Today vs. Yesterday by hour of day).  We are making marketing decisions in real time so it would be nice to have this capability.

Related, the charts in anlaysis workspace limit you to 20 line items.  I undestand the need to limit, but in the case where I would want to compare hour of day i would need at 24.  Can we bump the limit up to 25 : )

@benjamingaines When can we expect this to be released?

also - it would be nice to be able to a comparison of 'hour to date'  So if I am comparing today vs. yesterday i would have the ability to apply a segment to yesterday that matches the data available for today.

Example:

Current Date Time: 9/23/15 10am

Current Orders per Visit:: 6%

Yesterday Orders per Visit: 2%

Yesterday Orders per Visit through 10am: 7%

Being able to compare current conversion rates by time of day would be super helpful and cause people to pay attention in realtime vs. having to wait a day. (we can obvisouly visualize in other ways but it would be nice to have something out of the box)

again - apologies if this already exists.

These are all great points. Some thoughts:

1. For comparing hours of day across days, there's currently a bug (or perhaps bad design) related to the existence of the date in the rows when showing hour (as you pointed out). The result is that you can't really compare a single hour across days. That should be fixed in an upcoming release. 

2. Good point about 25 items in a graph. I'll send this over to our engineering team to review and hopefully get that increased.

3. This might be coming soon. We want to add rolling date ranges in segments; there are a ton of great use cases that would be solved by this. Either way, we'll keep an eye on this idea for votes and comments and make sure we're solving your need as we go.