how does stacker work?
Hi!
We received stacker and I need to figure out how it works, but I really have no clue whatsoever.
I'm used to doing stuff with MySQL, but what are the use cases, what are the best practices of the tool? What is it intended to do? What else can it do for us?
Thanks for any replies!
Best Answer
-
Hi!
Sorry to see this never got any replies. I'll give you a bit of insight from my perspective working with stacker.
Stacker works well when you have datasets from different sources that contain like metrics. A common use case for this would be social media data, where YouTube, Facebook, Instagram, etc. all contain similar metrics (Likes, Comments, Impressions, Clicks, etc.) but have unlike schemas that make them unwieldy to union or join together due to the amount of transformation required.
Enter stacker, where you can Name the metric column the same name (Likes), but that column can contain data from any number of datasets from different sources. So your YouTube column might be called "Video Likes" and your Facebook column could be "Page Likes, or Post Likes" and Instagram could be "Post Loves" or similar. You can put all those different named columns in stacker under a single metric column (Likes).
Once you've aligned the metric, you can include any dimension columns from any of the datasets, or create your own. So you can include a "Facebook" as `Platform` dimension, then replicate that for each platform. Then you can view likes by platform in your cards with minimal transformation!
This is just one example, but stacker is also a simple way to pivot or unpivot data, since case statements can be used to isolate specific rows into columns. You can also pull specific columns into the same column.
Hope this is helpful and hopefully you've had some success with stacker in recent months!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'6
Answers
-
Hi!
Sorry to see this never got any replies. I'll give you a bit of insight from my perspective working with stacker.
Stacker works well when you have datasets from different sources that contain like metrics. A common use case for this would be social media data, where YouTube, Facebook, Instagram, etc. all contain similar metrics (Likes, Comments, Impressions, Clicks, etc.) but have unlike schemas that make them unwieldy to union or join together due to the amount of transformation required.
Enter stacker, where you can Name the metric column the same name (Likes), but that column can contain data from any number of datasets from different sources. So your YouTube column might be called "Video Likes" and your Facebook column could be "Page Likes, or Post Likes" and Instagram could be "Post Loves" or similar. You can put all those different named columns in stacker under a single metric column (Likes).
Once you've aligned the metric, you can include any dimension columns from any of the datasets, or create your own. So you can include a "Facebook" as `Platform` dimension, then replicate that for each platform. Then you can view likes by platform in your cards with minimal transformation!
This is just one example, but stacker is also a simple way to pivot or unpivot data, since case statements can be used to isolate specific rows into columns. You can also pull specific columns into the same column.
Hope this is helpful and hopefully you've had some success with stacker in recent months!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'6 -
This is Amazing! This is exactly what I wanted to know, thank you very much for the reply!
I went throught some pretty painful transforms in the recent months, but I now see that could have been avoided.
I hope to use this in the near future.
Best regards,
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 754 Beast Mode
- 61 App Studio
- 41 Variables
- 693 Automate
- 178 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive