how does stacker work?
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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 468 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 193 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 173 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive