Day of Week Dimension in Report Builder | Community
Skip to main content
D
denise_arjunan1
Level 2
September 30, 2024
Question

Day of Week Dimension in Report Builder

  • September 30, 2024
  • 1 reply
  • 834 views

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!

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

1 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
October 1, 2024

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.

D
denise_arjunan1Author
Level 2
October 1, 2024

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

    Jennifer_Dungan
    Community Advisor and Adobe Champion
    Jennifer_DunganCommunity Advisor and Adobe Champion
    Community Advisor and Adobe Champion
    October 1, 2024

    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:

     

    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.

    Terms & ConditionsAccessibility statement

    Loading footer...