Best Practices for Large Financial Reports in Domo
I just wanted to propose a question that we are struggling with. I am wondering if there is anything you could do that is more intelligent than the out of the box solutions. Prepping the data in a certain way in an ETL would be an option for this if it would help us with the final user experience. We are trying to get here from raw datasets such as invoice or sales order lines.
Essentially, we have many individual tables like the one below (many more complex) where we need to compare different periods of data to one another across different slices of the business. Could be YoY or QoQ, or could be Actual to Forecast, etc.
In any of these cases, the pivot table chart type works great until we want to involve a calculation such as a difference or variance between years. As soon as we want to do that, we are largely forced to create each individual column as a beast mode and use a Table/Mega Table instead of a pivot. Apart from being time consuming for hundreds of cards, it can also be a bit overwhelming for less savvy users. Do you have any thoughts on this problem?
Thanks!!
0
Comments
-
Sure, I covered a bunch of Finance tutorials in this series of videos: https://www.youtube.com/watch?v=KwMkv_OqZn0&list=PLUy_qbtzH0S53Kfztj1IniPqaAdaA4iEC&index=5
They should give many tips on how you can systematically approach financial reporting.
Beyond that, I'd be happy to make myself available in a consultative / mentorship relationship!
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
This discussion has been closed.
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 693 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive