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?
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.
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:
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.