Expand my Community achievements bar.

Webinar: Adobe Customer Journey Analytics Product Innovations: A Quarterly Overview. Come learn for the Adobe Analytics Product team who will be covering AJO reporting, Graph-based Stitching, guided analysis for CJA, and more!

Day of Week Dimension in Report Builder

Avatar

Level 2

Are the out of the box date dimensions available in Report Builder? 

 

For example I am looking to pull in day of week in to a report that I am working on but can't find the out of the box dimensions in RB. 

 

Thanks!

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

3 Replies

Avatar

Community Advisor

Day of Week doesn't appear to be there for me either... you might have to take the date range and use Excel functions to convert it to "Day of Week"

 

=TEXT(A1, "dddd")

 

(Replace "A1" with the correct cell)

 

This should give you the Day of Week (if you can't pull it directly).

 

Or, if you need to filter the results, you may have to make a segment to apply to your request.

Avatar

Level 2

Thanks. Yeah we will try a segment since we need to review multiple days aggregated. ex. what is the average conversion rate for Sunday. 

Avatar

Community Advisor

Also remember that calculated metrics don't usually come with Report Builder either...

 

If you pull in Daily Granularity, you should be able to add the function to determine the day of week, then you should be able to create a conversion rate from the table only including the specific day of the week....  Using the SUMIF, you can sum only the values that are for Sunday, for instance:

 

Simplified Example:

Jennifer_Dungan_1-1727806709192.png

 

So I used the original formula to figure out the day of the week, then I used the SUMIF to only sum the values that match "Sunday".

 

 

Or you could create separate requests for each day of the week (using 7 different segments).

 

Either solution should work.