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.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 557 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 571 Beast Mode
- 11 App Studio
- 28 Variables
- 579 Automate
- 141 Apps
- 414 APIs & Domo Developer
- 23 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 352 Distribute
- 92 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
- 88 Community Announcements
- 4.8K Archive