Breakdown auto apply for future dates | Community
Skip to main content
R
Adobe Employee
RajatAr1Adobe Employee
Adobe Employee
February 13, 2025
Solved

Breakdown auto apply for future dates

  • February 13, 2025
  • 2 replies
  • 603 views

Hi Team 
I am using CJA (similar to Adobe Analytics)
I have a day as a Dimension Breakdown based on Day, Visitor_ID, Asset_ID
                                                               Events
Feb 1
        Visitor_ID
             Asset _ID
Feb 2
       Visitor_ID
             Asset _ID
Feb 3
       Visitor_ID
             Asset _ID
Feb 4..
      Visitor_ID
             Asset _ID....

Feb 28 (future date)   - I want to show the same breakdown to apply for the future dates as well, is there any way I can show this
The metric I am using is events

    Best answer by Jennifer_Dungan

    Actually, there is a way without using Report Builder (which I actually hate the behaviour of and avoid using myself). In particular the fact that you can only breakdown up to 5 items, this doesn't actually solve the issue.

     

    The trick is to use the "Breakdown by Position" option...

     

    So, because the max number of rows you can show in any Freeform table is 400, I make sure to choose a date range that is longer than 400 days.

     

    First, drag in Day, then access the gear icon, and make sure to check the "Breakdown by position" option.

     

    Now, select all 400 rows, and drag your next dimension onto the selection (so that all 400 rows get the breakdown).

     

    Because you already selected "Breakdown by position" before adding the second layer, this new level should inherit this setting (but just confirm to be sure).

     

    Next, for each of those, you need to make your third level breakdown (yes, this means doing in 400 times to be safe... unless you are sure no one will ever be looking at a long time frame).

     

    Now, once that is configured, you can change the panel date range back to your default time frame, and all new dates as they roll in will have the breakdowns.

    2 replies

    Harveer_SinghGi1
    Community Advisor
    Harveer_SinghGi1Community Advisor
    Community Advisor
    February 13, 2025

    Hi @rajatar1 ,

    One way to achieve this is using Freeform table builder but it will only allow breakdown of 5 items on first level and 1 item on second level,

    If you want to apply breakdown for more items then you can try creating the similar project through Projects API. What you can do is create a project with table builder with limited allowed breakdowns and then access it's definition through API and replicate that with more number of breakdowns to create a new projects through API.

    Cheers!

      Jennifer_Dungan
      Community Advisor and Adobe Champion
      Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
      Community Advisor and Adobe Champion
      February 13, 2025

      Actually, there is a way without using Report Builder (which I actually hate the behaviour of and avoid using myself). In particular the fact that you can only breakdown up to 5 items, this doesn't actually solve the issue.

       

      The trick is to use the "Breakdown by Position" option...

       

      So, because the max number of rows you can show in any Freeform table is 400, I make sure to choose a date range that is longer than 400 days.

       

      First, drag in Day, then access the gear icon, and make sure to check the "Breakdown by position" option.

       

      Now, select all 400 rows, and drag your next dimension onto the selection (so that all 400 rows get the breakdown).

       

      Because you already selected "Breakdown by position" before adding the second layer, this new level should inherit this setting (but just confirm to be sure).

       

      Next, for each of those, you need to make your third level breakdown (yes, this means doing in 400 times to be safe... unless you are sure no one will ever be looking at a long time frame).

       

      Now, once that is configured, you can change the panel date range back to your default time frame, and all new dates as they roll in will have the breakdowns.

        R
        Adobe Employee
        RajatAr1Adobe EmployeeAuthor
        Adobe Employee
        February 21, 2025

        Thanks @jennifer_dungan , worked!!

         

          Jennifer_Dungan
          Community Advisor and Adobe Champion
          Jennifer_DunganCommunity Advisor and Adobe Champion
          Community Advisor and Adobe Champion
          February 21, 2025

          You're very welcome. Glad it solved your issue.

          Terms & ConditionsAccessibility statement

          Loading footer...