Expand my Community achievements bar.

Applications for the 2024-2025 Adobe Analytics Champion Program are open!
SOLVED

Percentage change from prior period in freeform table

Avatar

Level 2

I'd like to build a freeform table that returns the percentage change from the prior period in the table.

Expected results would be something like my screenshot below that shows the Week period in rows and then the Visits metric as a field. The custom metric would then show the percentage lift or fall from the prior period used (week in this case).

Bonus if I could change the period from Day, Week, or Month and have the metric know this, but having separate metrics for standard date periods is no biggie. Thanks in advance!

 

philliptrost_0-1681413466719.png

 

BTW - If you utilize ChatGPT to help, don't bother - it hallucinates almost any answer for Adobe Analytics still.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

I was able to get a calculation that works, but definitely requires jumping through more hoops than it should. I'd upvote it as a feature request.

 

Here's demo data from our Evolytics sandbox with the calculated metric.

josh12_0-1681481934268.png

Here's the metric definition.  I feel like I've used too many containers but when I tried to refactor, I broke it so it be's what it be's

 

josh12_1-1681482050301.png

 

View solution in original post

6 Replies

Avatar

Community Advisor

I used to compare the time periods and get the percent change. But that's only for one time period to another. Like in the image you mentioned i didn't get it. If someone knows let us know here.

Avatar

Community Advisor

Yeah, I also have used the Percent Change function, but yeah, it really doesn't work for such a table.... Just against dimensions for a single comparison....

 

I even tried hacking it using "This Week" and "Last Week" designations in the calculated metric and "Make Dates Relative" feature... but no luck....

 

If I were doing this.. I would probably use Report Builder to pull out data at a set granularity (weekly, or daily, or monthly), then use Excel to calculate the rolling row percent changes.....

 

I know that's not really the answer you wanted though... but if you post an idea for the ability to make rolling date % change visualization I will absolutely upvote it!

Avatar

Community Advisor

@philliptrostAtleast, you can get the table you wanted through excel, not in adobe. Just kidding!! But yeah, if you post an idea for rolling % change I will upvote it too.

Avatar

Correct answer by
Community Advisor

I was able to get a calculation that works, but definitely requires jumping through more hoops than it should. I'd upvote it as a feature request.

 

Here's demo data from our Evolytics sandbox with the calculated metric.

josh12_0-1681481934268.png

Here's the metric definition.  I feel like I've used too many containers but when I tried to refactor, I broke it so it be's what it be's

 

josh12_1-1681482050301.png

 

Avatar

Level 2

Dude, it worked.
I knew that Cume average would be clutch; it's the same formula I've used for rolling averages. I must have not used enough containers, ha!
I'm going to read a bit more on the function, but I'll be able to apply this in SO MANY ways now.
Great work!