Rolling dates in CJA | Community
Skip to main content
G
GregoryRi
Level 2
July 29, 2025
Question

Rolling dates in CJA

  • July 29, 2025
  • 3 replies
  • 417 views

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!

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

3 replies

bjoern__koth
Community Advisor and Adobe Champion
bjoern__kothCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
July 29, 2025

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-date-ranges/create#date-range-builder

Cheers from Switzerland!
pradnya_balvir
Community Advisor
pradnya_balvirCommunity Advisor
Community Advisor
August 4, 2025

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

    G
    GregoryRiAuthor
    Level 2
    August 4, 2025

    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
    Community Advisor
    pradnya_balvirCommunity Advisor
    Community Advisor
    August 5, 2025

    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

    Terms & ConditionsAccessibility statement

    Loading footer...