Plotting Cumulative Graph In Adobe Analytics | Community
Skip to main content
R
ranka_ujjwal
Level 2
August 8, 2022
Solved

Plotting Cumulative Graph In Adobe Analytics

  • August 8, 2022
  • 1 reply
  • 2620 views

Hi,

  I want to plot cumulative graphs in AA. Currently it supports daily graph. Is there a way we can get it easily?

For now I am using custom date ranges to achieve it. But this is resulting in too much of manual effort.

 

Eg. of Custom Date Ranges Segments below

Use Case : AB Analysis

Best answer by Jennifer_Dungan

You can create a custom calculation metric for "Cumulative"

 

 

 

 

In Calculated Metrics do the following:

 

  • Add: Function
  • In the Select area, start searching for "Cumulative" (there is both "Cumulative" and "Cumulative Average"
  • Then as the screenshot above, you can specify either the number of rows you want to include (or use "0" to make the cumulative average use all rows in your report date range)
  • Then pull in the metric you want to use

 

Hopefully you have the rights to create custom metrics, or you may have to get your admin person to create a "Cumulative Average Metric X" that you can use in your reports.

 

 

 

Good luck.

1 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
August 8, 2022

You can create a custom calculation metric for "Cumulative"

 

 

 

 

In Calculated Metrics do the following:

 

  • Add: Function
  • In the Select area, start searching for "Cumulative" (there is both "Cumulative" and "Cumulative Average"
  • Then as the screenshot above, you can specify either the number of rows you want to include (or use "0" to make the cumulative average use all rows in your report date range)
  • Then pull in the metric you want to use

 

Hopefully you have the rights to create custom metrics, or you may have to get your admin person to create a "Cumulative Average Metric X" that you can use in your reports.

 

 

 

Good luck.

    R
    ranka_ujjwalAuthor
    Level 2
    August 8, 2022

    This works!

     

    This method works like a charm for metrics which are additive in nature eg. Orders, no. of page views.

    Although for Unique Visitors(UV) it gives different values than what I wanted.

     

    Eg. Data at a Daily Level

    Aug 1 has 10 UVs

    Aug 2 has 10 UVs

     

    Now for Aug 1 to Aug 2 :
    UV count will be less than 20 as some visitors are getting repeated and not 10+10 = 20.

     

    Currently the above method gives 20, Is there any work around for metrics which are not additive?

     

     

    R
    ranka_ujjwalAuthor
    Level 2
    August 8, 2022

    @ranka_ujjwal I just checked with some Adobe folks... they are aware of this, but it's in the backlog..... 

    If you need cumulative reports for UVs you may be stuck with the date range option....

     

    However, have you considered creating rolling date ranges?

     


    And


    That you can reuse every month?

     

    It will require manual setup... but then it can be reused, as opposed to setting up specific "Aug 1" and "Aug 1-2", etc ranges....

    (Months with 28 and 30 days get a little complicated), but it still might save you some work.... unless someone needs to go back and check older data....  you might need to do Previous Month and Current Month, etc for MOM comparisons......




    Ah

     

    I hope this gets resolved for metrics which are not additive.

    Although, thanks for the suggestions Jennifer!

      Terms & ConditionsAccessibility statement

      Loading footer...