Hi, I'd like to merge my Forecast and Actual data into a single table.
To do this, I created these metrics:
'IsActual Metric':
'Switchover date Metric':
'Growth Rate Hypothesis'
'PREVIOUS_(Month
)'
'FCST - Product': which should be my result. But the problem is that I get one result per Version, even though I need to have the 5-month Actual and 7-month Forecast data in the same table. Thank you very much for your help.
Hi,
do you have Data in Sales_by_product ?
Hi,
Yes below. Thanks for your help
You have all versions selected, could you select one ?
You can try to drill down on the empty cell and find where you data is BLANK
Hi
I’ve checked your solution but removed the product dimension for simplicity. Based on what I see, it seems to work.
However, if your Sales_by_Product only contains data on the Actual version, then your formula won’t pull it into the remaing versions.
Also, I don’t expect to see any plan data in 2023, because the Plan version switchover is 24 Jan.
This could explain why you only see 1x the plan in 2023, which is likely on the Forecase 1 version.
You’ll need to check where you’re pulling data from, especially if the source metric (Sales_by_Product) contains data on the same version you’re expecting in your calculation. Could you confirm which versions have data in the Sales_by_Product metric? I can see actuals, but what about the others versions? Also, why is there a yellow warning in this metric?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.