Calculations using analyser or beast mode
Hi, I have figures from a dataset that I need to carry out calculations on (addition, subtract etc). In the attached, columns 'CAP' and 'ITB Not Built' use different filters to get the final number.
All I need to do is add CAP and ITB Not Built together for each client.
Pipeline is just these two figures put together.
Balance is Target - Pipeline.
It's fairly straight forward, I can get all the data in individual cards but I wasn't sure on the best way to carry out these calculations?
Cheers!
Answers
-
You can utilize a formula tile in a magic ETL dataflow or just use a beast mode.
I'd recommend utilizing the Magic ETL as that will take most of the processing and allow cards to load faster.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Can you provide a little more commentary about what exactly you are looking to solve for here? It looks to me like you've already figured out the solution.
If you're looking to calculate numbers based on different filter criteria I'd recommend using a CASE statement on a beast mode or in magic ETL to solve.
Pretend I'm running a fruit stand -- I have 3 apples (that are red), 2 peaches (that are pink), and 5 blueberries (which are blue). I want to lump anything that is red or pink into a 'red' bucket.
I can write a beastmode called 'red fruits':
CASE WHEN
fruit color
IN ('Red', 'Pink') Then SUM(Quantity)
EndThis would add apples and peaches together.
1 -
So we have our yearly targets: Client A = 80, Client B = 100, Client C = 40
We need to work out our balance of sites that we need in order to hit yearly targets, the calculation is 'Target - Completed Awaiting Power - Instructed and not built'.
At the moment I have figures for completed awaiting power and ITB not built in separate cards, but I wasn't sure how to get these figures into one dataset in order to carry out the calculation.
The screenshot in the previous comment is on Excel, I just need to replicate this in Domo.
Does this help?
0 -
Hi @louisshh ,
Also trying to help, but still confused by what has been written. I'm fairly unclear of what you're trying to do. If you can maybe send a video instead that might clear things up.
John Le
You're only one dashboard away.
More video solutions at: https://www.dashboarddudes.com/pantry
John Le
You're only one dashboard away.
Click here for more video solutions:
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive