Rolling dates in CJA

[GregoryRi]

Hello - can you explain how I set up rolling dates on the calendar in CJA? It's unclear from the CJA overview study guide. Is there a formula or something that I can apply to any rolling dates, whether weekly, monthly, yearly, etc.?

This scenario for example:

- Current reporting period is Sunday-Monday and I want to set up a report for Saturday - Sunday so that I can review on Monday morning.

Let's say I'm setting up the report today (Monday 7/28) so this is our current week. Can you please walk me through step-by-step how I set this up and explain why for each step.

For example:

- What would the start date be, and why?

- What would the end date be, and why?

Thanks!

[bjoern__koth]

Hi @GregoryRi 

I think l you might want to have a look at the advanced settings in the calendar.

There you can build expressions like subtracting days from the current day. To my knowledge, it is not possible to say "last Saturday and Sunday" though. But if you're always evaluating this on a Monday morning, I think the date subtraction should work for you. I would call it "last two full days" though to be more generic.

https://experienceleague.adobe.com/en/docs/analytics/analyze/analysis-workspace/components/calendar-...

[pradnya_balvir]

Hi @GregoryRi ,

Setting up rolling dates in Customer Journey Analytics (CJA) is a bit different than in Adobe Analytics, as CJA allows for relative date ranges using rolling logic, which makes it ideal for automated weekly or daily reporting.

1. Go to your Date Range settings

In CJA:

• Go to your panel or component and click on the date range selector.

• Click “Create Date Range” or “Add Rolling Date Range”

2. Configure the Rolling Logic

Start Date:

• Select: Start: 2 days ago

• Why?

  • Today is Monday (7/28), so “2 days ago” is Saturday (7/26) — the first day of your target window.

End Date:

• Select: End: 1 day ago

• Why?

  • “1 day ago” from Monday is Sunday (7/27) — the second day of your weekend window.

This rolling window will always give you the most recent Saturday–Sunday, no matter which Monday you're viewing the report on.

3. Name Your Date Range

Give it a clear name like:

Rolling Weekend (Sat-Sun Prior to This Week)

This helps you or others reuse it consistently.

4. Apply This Custom Date Range

• You can use this as a date filter in a panel, freeform table, or calculated metric.

You can save this rolling date range as a Component to reuse across dashboards or other workspaces.

Thanks.

Pradnya

[GregoryRi]

This is great thank you. So in this scenario if I wanted this report to go from Saturday to Friday (and I’m setting up on the same Monday 7/28), would this be correct?

1. Start date: minus 2 days (ie 2 days ago using the same rationale you listed below)

2. End date - plus 4 days 

        Why? Because the first reporting period (Friday 8/1) hasn’t ended yet and will in 4 days. So the first report would be generated the following week using dates Sat 7/26 - Fri 8/1

Is that right? 

[pradnya_balvir]

Hi @GregoryRi ,

You're setting up the report on Monday, 7/28 and you want each report to cover the most recent Saturday - Friday period.

However, since today is Monday, the current week's Friday (8/1) hasn't happened yet so you're aiming to build a rolling window that always captures last week's Saturday–Friday once that full period is complete.

for a completed Saturday–Friday period

Use These Rolling Date Offsets:

• Start date: 9 days ago

  • Why? Today is Monday (7/28), so 9 days ago = Saturday, 7/19

  • That gives you the start of last week's Saturday–Friday range

• End date: 3 days ago

  • Why? 3 days ago = Friday, 7/25

  • That gives you the end of last week's Friday

This ensures that the rolling window always shows the previous Saturday–Friday period and never includes partial current-week data.

I hope this helps you.

Regards,

Pradnya