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:
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Categories
- 10.6K All Categories
- 1 APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 252 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 63 Kowaza
- 296 仲間に相談
- 649 ひらめき共有