Breakdown auto apply for future dates

[RajatAr1]

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

[Harveer_SinghGi1]

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 · Accepted solution]

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.

[RajatAr1]

Thanks @Jennifer_Dungan , worked!!

[Jennifer_Dungan]

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