Day of Week Dimension in Report Builder

[denise_arjunan1]

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!

[Jennifer_Dungan]

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.

[denise_arjunan1]

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]

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.