Beastmode filter computation
I want to know if there is a way to do the following in Beastmode.
I have a dataset with sales of asian countries
1). I want to filter and get the sum of only Japan and Taiwan.
2). I want to use the result of 1 in a computation such as SUM(Japan_sales and Taiwan_sales)/SUM(Asian of all countries)
I can't use ETL or dataflow for some reason.
Best Answer
-
You might be able to do something like this:
SUM( CASE WHEN `countrycolumn` IN ('Japan','Taiwan') THEN `Sales Amount`
END)
/
SUM( `Sales Amount`)You should be able to limit the the sales of only Japan and Taiwan in the numerator and then sum everything (since your dataset is 'Asian countries') in the denominator.
Let me know if you have any questions,
Valiant
2
Answers
-
You might be able to do something like this:
SUM( CASE WHEN `countrycolumn` IN ('Japan','Taiwan') THEN `Sales Amount`
END)
/
SUM( `Sales Amount`)You should be able to limit the the sales of only Japan and Taiwan in the numerator and then sum everything (since your dataset is 'Asian countries') in the denominator.
Let me know if you have any questions,
Valiant
2 -
@Valiant Thanks a lot! this might do the magic ?
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 738 Beast Mode
- 56 App Studio
- 40 Variables
- 684 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 35 Predict
- 14 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 123 Manage
- 120 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