Expand my Community achievements bar.

Announcement: Calling all learners and mentors! Applications are now open for the Adobe Analytics 2024 Mentorship Program! Come learn from the best to prepare for an official certification in Adobe Analytics.

## Calculated Metric using percentage increase

Level 1

I'm trying to create a calculated metric based on a percentage increase over an existing metric.

For example, I want to calculate a 10% increase over page visits in the same month last year. So let's say there were 10,000 page visits in April 2023, and I want the metric to spit out the answer to 10,000 + 10%.

If you have any ideas, I would love to hear them!

3 Replies

You should be able to make a calculated metric with the metric of interest and a static number.

Metric

X

Static Number 1.10

That would result in being 10% more than what the value currently is for your time period. If you want it to be based on last year's number you would either need to just set the panel date range to last year or use a custom date range for that row/column.

Hi, would my assumption be correct that you might be trying to create a rolling target, based on a 10% increase from the previous month... so it's not "locked" to a specific value like 10,000...

Basically

• Jan: actual traffic was 10,000, so the target for Feb would be a 10% percent change (i.e. 11,000)
• Feb: actual traffic exceeded the budget, and was 13,452, so the target for March would be something like 14,797
• etc

Basically, instead of calculating the actual percent change between two numbers:

You want to know what V2 should be, based on a percent change of 10%?

I believe this is the basic formula you would need:

Note: this is just based on the current date range of the panel...  I didn't build any date control into the calculation...