Analysis Workspace: Creating an Hour Dimension without the date details | Community
Skip to main content
J
jeremyl59043873
Level 3
June 22, 2016
Solved

Analysis Workspace: Creating an Hour Dimension without the date details

  • June 22, 2016
  • 1 reply
  • 2139 views

Hello

I'm looking to create a view in analysis workspace that would allow me to compare across days, traffic by hour.

the format of the freeform I had in mind would be

Hour        today        today-1        today-2        today-3, etc

1

2

3

4

etc

 

Is there already or does anyone know of a way to create a new dimension for 'hour' that would allow me to do this?

The existing 'hour' dimension that is in Analysis Workspace includes the 'date' part of the datetime stamp.  i'm just looking for the time part.

It would be great if we do the same thing for 'minutes' or even every 'quarter hour'

Please advise if you have any ideas

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by TanmayMathur

Hi Jeremy,

If this is long term requirement, you can look at implementing the getTimeParting plugin described here - https://marketing.adobe.com/resources/help/en_US/sc/implement/getTimeParting.html

The hour dimension available in workspace would let you define a specific hour of a specific day. 

If you want to do this in workspace without implementation changes, one workaround could be to create a separate segment for every hour of the specific days. The layout could be like:

Visits    Hour of today    Hour of today-1    Hour of today-2    Hour of today-3

If you want to extract the data in the format you suggested, you might want to try it via Report Builder. 

I hope this was helpful. Thanks!

Tanmay

1 reply

TanmayMathur
Adobe Employee
TanmayMathurAdobe EmployeeAccepted solution
Adobe Employee
June 27, 2016

Hi Jeremy,

If this is long term requirement, you can look at implementing the getTimeParting plugin described here - https://marketing.adobe.com/resources/help/en_US/sc/implement/getTimeParting.html

The hour dimension available in workspace would let you define a specific hour of a specific day. 

If you want to do this in workspace without implementation changes, one workaround could be to create a separate segment for every hour of the specific days. The layout could be like:

Visits    Hour of today    Hour of today-1    Hour of today-2    Hour of today-3

If you want to extract the data in the format you suggested, you might want to try it via Report Builder. 

I hope this was helpful. Thanks!

Tanmay

Terms & ConditionsAccessibility statement

Loading footer...