How to use value from beast mode as a value for all?
Hi, I am trying to figure out how to best solve my issue. I currently have a calculation in my dataflow attached to a certain account code for our organization. That value changes daily but I need to use that value to divide the rest of our account codes by so I can't just add a constant value. Because it is attached to the one account it is showing 0 for all of the others. Is there a way to make it so the value is being used can be used for all of the other account codes since I ultimately need to exclude the account that the original calculation is created with in the card view. Maybe there is a way to do it within the dataflow?
Answers
-
If you have a constant value from your calculation you can apply that value by doing a Cartesian join. To do this use a formula tile to add a new column called Join and set its value to 1. Feed this into a filter to only get your single value for the specific code. Then duplicate that filter and change it so it’s getting all values except your specific code. This should be coming from your formula tile and not the filter tile. Then take the output from your two filters and join them together based on the Join column your defined in the formula tile earlier. Rename the columns as necessary. You should now have an output with your original data and the calculated value for each row
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Hi Grant,
I am a little confused on what the filters you are talking about. Am I suppose to be filtering on the account code that the calculation is attached to? and then lead that into another filter with everything but that account code? Also should the first formula tile be connected to my input dataset or should it be after the calculation formula?
Thanks/
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 298 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 54 App Studio
- 40 Variables
- 680 Automate
- 175 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 33 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive