Date Range relative to project's date range | Community
Skip to main content
Level 2
August 15, 2017
Declined

Date Range relative to project's date range

  • August 15, 2017
  • 5 replies
  • 8001 views

Currently in Workspace, we have Date Ranges like "This Month", "Last Month", "Last 7 days", etc. But these date ranges are relative to your current date.

What I would like are date ranges that are relative to my project's date range.

Example 1:

Today is 15 August 2017.

I run a report for 1-31 July 2017.

The "Previous Month" date range would show the data for 1-30 June 2017, i.e. the month previous to 1-31 July 2017.

Example 2:

Today is 15 August 2017.

I run a report for 1-31 January 2017.

The "Previous Month" date range would show the data for 1-31 December 2016, i.e. the month previous to 1-31 January 2017.

And similarly for "Next Month".

And similarly for other time periods, e.g. day, week, month, quarter, year.

5 replies

Urs_Boller
Community Advisor
Community Advisor
August 15, 2017

hi, i added the same idea a few days ago: Dynamic date ranges

Gigazelle
Adobe Employee
Adobe Employee
March 29, 2019

Marking as duplicate of: Dynamic date ranges

Urs_Boller
Community Advisor
Community Advisor
April 29, 2019

Gigazelle​ the ideas are not the same: this one here is about new date ranges depending on project date range. can you re-open the idea? thanks!

Level 4
February 21, 2020

PLEEEEZ add this functionality!

Biggsy50
Level 3
May 24, 2024

@yuhui_sparkline & @nickhomer I "think" this might now be fixed in Adobe Analytics if I've understood you correctly?

 

So I wanted my table to simply show the visits for last month (April 2024) compared to visits for the previous month (March 2024). Then if I choose an older month in my table's panel calender (or set it to automatically roll along), e.g. Feb 2024, then the previous month column would change to Jan 2024 and not remain as March 2024.

Before


After

 

I did this by checking the 'Make date range components relative to panel calender' box in the panel calender advanced settings.

 

NB. When I instead right-clicked on the lone 'Visit' column, selected 'Add time period column' & then 'Prior month to this date range' this did not work and the previous month stayed fixed incorrectly to March 2024.

 

Thanks,

Steve Biggs