Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Coffee Break: Join us on Wednesday, April 5th at 10am PT to chat with Ben Gaines, Director of Product Management for Adobe Analytics. Ben will be online to answer your Analytics and Adobe Summit questions.

Adding forecast as a metric calculation


Level 2

I try to make the following forecast trend using static number and Day as a filter:


When I try to draw this metrics on a visual it sum both number on ever day. How can I make a statical forecast trend with different numbers for each day?

3 Replies


Community Advisor

Dont understand the logic here completely but I assume you are trying to create a metric whereby you trend against a future target number vs present day?


Not sure this is exactly what you are after but, if you created a calculated metric against a Dimension KPI.


In this case metric is pageviews x exp % change of 15 % increase.

Screen Shot 2021-10-18 at 12.21.27 PM.png


Then you add 2nd calculated dimension vs reg dimension to see deltas.


Good luck


Level 2

Hello! First of all, thank you for your reply.


What I need is the following. We are going to launch a Paid Media campaign and I have a revenue forecast type:
Day 1 - 100
Day 2 - 70
Day 3 - 65
Day 4 - 120
Day 5 - 90


What I want is to be able to plot this trend on a graph so that I can compare it with the actual result, type:




Community Advisor

ok thanks for clarifying further. The main challenge here is user data on revenue is usually attributed at time of purchase via product/revenue data capture.


You almost would need a 3rd party powerBI like way to do this data insertion and comparison.


From what I see likely easiest way to go export data results, use excel to make graphs. APi insertion is possible but that leads to alot of work in other areas.


good luck

The ultimate experience is back.

Join us in Vegas to build skills, learn from the world's top brands, and be inspired.

Register Now