Percentage change from prior period in freeform table

Question

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!

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

Josh Stephens · Accepted Answer

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.

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 🙂

Jennifer_Dungan · Answer

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!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded