Adding forecast as a metric calculation

[amendez92]

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?

[Pablo_Childe]

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.

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

Good luck

 

[amendez92]

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:

[Pablo_Childe · Accepted solution]

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