Compare two tables and find the difference

Im trying to move some of our reporting we do onto Domo. One of the things we do is build scenarios and need to compare them to what's happening currently. In excel we have this so the top table shows current data with locations by hour with a number filled in for the value. we then have a scenario table underneath this with the same data points, then below is a third table with the difference. wondering what would be the best way to set this up in demo so both the current and scenario can be changed, as different days of the weeks would have different values and scenarios made
Best Answer
-
To replicate what you are doing in excel, you could keep the source data in excel for any or all of the tables, connect them to Domo using the OneDrive for Business Connector, upload them using the file upload connector, use the Email connector to have the files sent by someone to Domo via email, setup SFTP, or use the Domo webforms connector to enter the values directly in a spreadsheet in Domo.
Comparing the values could be done in single or multiple table cards on a dashboard.
Additionally, using variables you could test different what if scenarios in realtime on the dashboard.If I solved your problem, please select "yes" above
0
Answers
-
To replicate what you are doing in excel, you could keep the source data in excel for any or all of the tables, connect them to Domo using the OneDrive for Business Connector, upload them using the file upload connector, use the Email connector to have the files sent by someone to Domo via email, setup SFTP, or use the Domo webforms connector to enter the values directly in a spreadsheet in Domo.
Comparing the values could be done in single or multiple table cards on a dashboard.
Additionally, using variables you could test different what if scenarios in realtime on the dashboard.If I solved your problem, please select "yes" above
0 -
What would be the best way to filter for the two results i want in the table if i have say 100 scenarios in my data, once again, one table for one scenario, anther table for one other scenario and then the last table with the difference between them
0 -
In MagicETL, you could do outer joins between your actuals and scenarios. If you want all scenarios available for both the first and second filter, then you could join the scenarios twice, renaming the columns on the join to distinguish. So basically Actuals x Scenarios copy 1 x Scenarios copy 2. Then you could do all the math for difference between scenarios in a formula tile.
This is a wildly simplified version of what your data might look like; each column stands in for some group of columns you want to display in your tables. This structure would allow you to filter your multiple scenarios and see the differences in results. You could view them all in one table, or split between 3 tables, with filters that apply to all three tables.
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 656 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 811 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 80 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive