Adding extra budget condition in Beast Mode
Options
PJG
Member
Hi team! This is my first post here, and I'm very new to this. I've built some incredible dashboards in Domo, but when it comes to code, I struggle a lot.
I have this simple Beast Mode working well (although it won't paste those funky apostrophes):
case
when Actual Costs
> Planned Costs
* 1.01 then 'Over Budget'
when Actual Costs
< Planned Costs
* 1.01 then 'Under Budget'
End
need to change the conditions a little to follow these rules:
- <1% & > 20k = Over Budget
- >1% & > 5k = Over Budget
- else, Under Budget
How would I write this as code?
Thank you so much!
0
Best Answer
-
Hi @PJG you could do something like this:
case when
Actual Costs
<Planned Costs
*1.01 ANDActual Costs
-Planned Costs
> 20000 then 'Over Budget' whenActual Costs
>Planned Costs
*1.01 ANDActual Costs
-Planned Costs
> 5000 then 'Over Budget' else 'Under Budget' end2
Answers
-
Hi @PJG you could do something like this:
case when
Actual Costs
<Planned Costs
*1.01 ANDActual Costs
-Planned Costs
> 20000 then 'Over Budget' whenActual Costs
>Planned Costs
*1.01 ANDActual Costs
-Planned Costs
> 5000 then 'Over Budget' else 'Under Budget' end2 -
Wow, that reply was incredibly fast!!! And it works; thank you so much; I didn't realize it would be that simple!
1
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 89 SQL DataFlows
- 556 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 569 Beast Mode
- 11 App Studio
- 27 Variables
- 578 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 23 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive