Trying to forecast revenue using last year’s data and the current runrate in the past 7 days.
To do this, I created 2 different tiles - 1. last year revenue trend 2. last 7 days’ runrate to predict the 8th day’s revenue
Context: I need to use the predicted 8th day’s revenue as a starting point and use the patterns from last year’s revenue to predict the current month’s revenue.
Question: is it possible to leverage the number I get from the 2nd tile in the 1st tile without having to manually copy and paste the number? I’d like to automate this report instead of doing it manually every month.