Storing Projected Values
I have a graph setup giving me daily data. (e.g. sales). I've used as part of the graph "MultiPeriod Projection" and set it for 5 days out. What I want to know is how accurate this is to the actual. Today is 1/31/2023 and sales was $1M, and the prejection for 2/3/2024 is $1.3M, I want to know how close the projection was to the actual for that day. To do this, I need to know what the project was today and then compare to the actual. How do I store/retain the projecte amount?
Best Answers

Short answer: you can't.
Long answer: Projected values update in real time as new data becomes available. You could store the projected values in a beastmode or in a webform and join them back to your data, but at what point would you consider them locked in? 1 day out? 3 days out? It sounds like perhaps this is just a curiosity thing in which case I would just jot them down and see how well they perform. If you actually need to measure the variance to the projected values I would recommend projecting your own values using linear regression with scripting tiles (python, R) in magic ETL or in a Jupyter Workspace.
If I solved your problem, please select "yes" above
0 
What would be functionally equivalent is to retroactively calculate what the projections would have been for your entire data set, so you can see historically how your actuals compare to your forecasts. If you're using linear regression, I played with an approach where I tool @marcel_luthi 's data setup from this thread on rolling averages:
And create a scatter where the xaxis is preexisting date, the yaxis is preexisting value, and the series is the date. Then you can see all the past regressions (and filter for which regression you want):
Disadvantage, is ideally I would be able to connect these points with a line graph, but as far as I can tell, you can't have multiple regression lines on any of the line graph options.
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0
Answers

Short answer: you can't.
Long answer: Projected values update in real time as new data becomes available. You could store the projected values in a beastmode or in a webform and join them back to your data, but at what point would you consider them locked in? 1 day out? 3 days out? It sounds like perhaps this is just a curiosity thing in which case I would just jot them down and see how well they perform. If you actually need to measure the variance to the projected values I would recommend projecting your own values using linear regression with scripting tiles (python, R) in magic ETL or in a Jupyter Workspace.
If I solved your problem, please select "yes" above
0 
I understand what you are stating. Just hoping for some easy way to do this without someone remembering to write them down. I would say we could do it for a week or two and then just do a check every other month for about a week.
Thank you for your help.
0 
What would be functionally equivalent is to retroactively calculate what the projections would have been for your entire data set, so you can see historically how your actuals compare to your forecasts. If you're using linear regression, I played with an approach where I tool @marcel_luthi 's data setup from this thread on rolling averages:
And create a scatter where the xaxis is preexisting date, the yaxis is preexisting value, and the series is the date. Then you can see all the past regressions (and filter for which regression you want):
Disadvantage, is ideally I would be able to connect these points with a line graph, but as far as I can tell, you can't have multiple regression lines on any of the line graph options.
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0 
David,
This gives me some other approaches and thought. I really appreciate it.
Thank you,
1
Categories
 All Categories
 1.8K Product Ideas
 1.8K Ideas Exchange
 1.5K Connect
 1.2K Connectors
 299 Workbench
 6 Cloud Amplifier
 8 Federated
 2.9K Transform
 100 SQL DataFlows
 616 Datasets
 2.2K Magic ETL
 3.8K Visualize
 2.5K Charting
 729 Beast Mode
 55 App Studio
 40 Variables
 682 Automate
 175 Apps
 451 APIs & Domo Developer
 46 Workflows
 10 DomoAI
 34 Predict
 14 Jupyter Workspaces
 20 R & Python Tiles
 394 Distribute
 113 Domo Everywhere
 275 Scheduled Reports
 6 Software Integrations
 121 Manage
 118 Governance & Security
 Domo Community Gallery
 38 Product Releases
 10 Domo University
 5.4K Community Forums
 40 Getting Started
 30 Community Member Introductions
 108 Community Announcements
 4.8K Archive