Handling multiple aggregation levels from source data
My company uses syndicated POS data from sources like IRI, NPD, and retailer POS. There are many measures that cannot be aggregated from the item level data, so I need to bring in pre-aggregated data in addition to the non-aggregated data. I was planning to have one column that indicated the aggregation level, but when I thought about how I would be using the different level, I need to be able to use them in drill downs. However, since drill downs take the filters from the previous card in the drill down series, I don't think this will work to filter the aggregation level. If anyone has posted articles or has an best practices for multiple level of aggregation of the same data, please let me know. I could just have different datasets for each aggregation level, but then I don't think they would "interact" the way I want them to.
Best Answer
-
@jaeW_at_Onyx often recommends appending your data so that you have one larger dataset and allows you to easily perform drill paths. I would encourage you to look at the videos he has posted as there is likely one that covers this:
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Answers
-
@jaeW_at_Onyx often recommends appending your data so that you have one larger dataset and allows you to easily perform drill paths. I would encourage you to look at the videos he has posted as there is likely one that covers this:
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 542 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 344 Distribute
- 86 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 6 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive