Creating a Beastmode/ Dimension
I have a set of data that includes columns like " Facebook Engagements, Facebook Impressions, Twitter Engagements, Twitter Post Impressions, TikTok engagements, TikTok Impressions" how do I create a dimension or beastmode where you will be able to filter by platform, e.g.: Facebook, Twitter, TikTok.
Best Answers
-
Create a platform field formula. Then filter on the new field.
CASE
WHEN `Facebook Engagements` IS NOT NULL OR `Facebook Impressions` IS NOT NULL THEN 'Facebook'
WHEN `Twitter Engagements` IS NOT NULL OR `Twitter Post Impressions` IS NOT NULL THEN 'Twitter'
WHEN `TikTok Engagements` IS NOT NULL OR `TikTok Impressions` IS NOT NULL THEN 'TikTok'
ELSE 'Other'
END** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
Hi - Is sounds as if your data is not set up for this, I would recommend using Magic ETL.
The steps would be:
- Add a Select Columns, choose your conforming dimensions and your Facebook specific columns
- rename Facebook Engagements as Engagements, rename Facebook Impressions as Impressions, etc.
- Add a Select Columns for Twitter and TikTok in the same way
- After each select columns add a Add Constants tile and create a constant column named "Platform" and set the value equal to the platform
- Then use the Append tile to append the 3 Select Columns together
- Next add a filter to remove all rows where Impressions AND Engagements are NULL - this step is not required but helps clean up empty space in the data
- connect the filter to an output dataset and build your cards off of this output.
Hope that helps!
0 - Add a Select Columns, choose your conforming dimensions and your Facebook specific columns
Answers
-
Create a platform field formula. Then filter on the new field.
CASE
WHEN `Facebook Engagements` IS NOT NULL OR `Facebook Impressions` IS NOT NULL THEN 'Facebook'
WHEN `Twitter Engagements` IS NOT NULL OR `Twitter Post Impressions` IS NOT NULL THEN 'Twitter'
WHEN `TikTok Engagements` IS NOT NULL OR `TikTok Impressions` IS NOT NULL THEN 'TikTok'
ELSE 'Other'
END** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
Thank you so much! I will attempt to build this formula and follow-up if it works! Greatly appreciate the support!
0 -
Following up : The only filter showing up is Facebook although there is data across all the other social platforms. To add some context, all the columns are set as dimensions, so we want any dimension (column) that includes the word Facebook to be filtered as "Facebook", all that include the word "Twitter" to be filtered at "Twitter" etc.
0 -
Hi - Is sounds as if your data is not set up for this, I would recommend using Magic ETL.
The steps would be:
- Add a Select Columns, choose your conforming dimensions and your Facebook specific columns
- rename Facebook Engagements as Engagements, rename Facebook Impressions as Impressions, etc.
- Add a Select Columns for Twitter and TikTok in the same way
- After each select columns add a Add Constants tile and create a constant column named "Platform" and set the value equal to the platform
- Then use the Append tile to append the 3 Select Columns together
- Next add a filter to remove all rows where Impressions AND Engagements are NULL - this step is not required but helps clean up empty space in the data
- connect the filter to an output dataset and build your cards off of this output.
Hope that helps!
0 - Add a Select Columns, choose your conforming dimensions and your Facebook specific columns
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 744 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive