Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Is there a way to pull multiple custom date ranges at once in Report Builder?

Avatar

Avatar
Validate 1
Level 1
dons94228514
Level 1

Likes

0 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
dons94228514
Level 1

Likes

0 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
dons94228514
Level 1

22-02-2017

I'm using Report Builder and I need to pull both historical and ongoing monthly data by custom dates for a client that wants to change reporting from calendar months to a 5-4-4 fiscal calendar. I've had multiple reports set up as "Last 2 months" date range and Monthly granularity so I can have this month's and last month's numbers for each line of each report, but I can't seem to find a way to do this if I have to specify custom dates for each month. Is there anything similar to Site Catalyst's Compare Dates option that lets you pull data for two different custom ranges in the same report?

Another possible workaround is to switch to using the Custom Calendar with the 4-5-4 option, but apparently that doesn't work for historical data when you change to it. I might also change back to Site Catalyst but I'd rather not.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Springboard
Community Manager
jantzen_belliston-Adobe
Community Manager

Likes

329 likes

Total Posts

2,247 posts

Correct Reply

811 solutions
Top badges earned
Springboard
Validate 500
Validate 250
Validate 100
Validate 50
View profile

Avatar
Springboard
Community Manager
jantzen_belliston-Adobe
Community Manager

Likes

329 likes

Total Posts

2,247 posts

Correct Reply

811 solutions
Top badges earned
Springboard
Validate 500
Validate 250
Validate 100
Validate 50
View profile
jantzen_belliston-Adobe
Community Manager

05-03-2021

Since this is an older post, I'm assuming you've solved this issue. Incase others find this post, I'll post the link to the documentation below:

https://experienceleague.adobe.com/docs/analytics/analyze/report-builder/home.html?lang=en#report-bu...

Answers (0)