Using Weighted Data with Cards
When working with data and building cards, is there any way to utilize beast modes to apply a weighted value across multiple variables? There is a weight variable within the dataset, and we are trying to apply those varying weights and display the updated values on a dashboard. Does the SQL syntax have the capability of multiplying two variables together within beast modes? If not, does DOMO ETL have this function available? Or does it make more sense to weight our data using SAS or R and then upload those values to DOMO?
Best Answers
-
Hi @mcruz24 , I think what you are asking is can you multiply two fields together to create a new field, example: Value * Weight = Weighted Value.
You can do this in an ETL or in a beastmode.
For the beastmode, it would look like this (swapping out your field names):
`Value` * `Weight`
Then, you can use that beastmode as a field in your visualization.
If I solved your problem, please select "yes" above
1 -
To add on to @ColemenWilson 's suggestion, you can multiply a value by another value using a conditional statement. For example:
Case
when
demographic
= 'male' thenscore
* 2when
demographic
= 'female' thenscore
* 1.5else
score
* 1.0end
0
Answers
-
No, to give more background, we have survey data that needs to be weighted, and we want to create cards illustrating the weighted data. Looking through the functionality of DOMO ETL and beast modes, we are curious if we can weigh the data within DOMO itself, using either an ETL or beast mode, and apply them to cards. For example, we have a variable X and want to apply the weight of Y; I know that in SAS, we have the functionality of applying Y to each level of X, changing the values of X.
0 -
Hello @mcruz24 ,
Yes, you can use variables to create weighted options and its usually the go to option to ensure your data is dynamically calculating the values. I have a few demo pages that use variables you could review for some ideas and sample codes. Take a look and let me know if you have any questions.
Variables - This page has a few examples of how to use variables in calculations.
0 -
Hi @mcruz24 , I think what you are asking is can you multiply two fields together to create a new field, example: Value * Weight = Weighted Value.
You can do this in an ETL or in a beastmode.
For the beastmode, it would look like this (swapping out your field names):
`Value` * `Weight`
Then, you can use that beastmode as a field in your visualization.
If I solved your problem, please select "yes" above
1 -
To add on to @ColemenWilson 's suggestion, you can multiply a value by another value using a conditional statement. For example:
Case
when
demographic
= 'male' thenscore
* 2when
demographic
= 'female' thenscore
* 1.5else
score
* 1.0end
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
- 101 SQL DataFlows
- 623 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 690 Automate
- 177 Apps
- 455 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive