How do I translate this Tableau code to Domo?
Hi,
So I need to translate code from Tableau to Domo and since I am very new to Domo, I will need your help to translate this Tableau code that looks like this:
{ FIXED [Employee ID],[Area Code],[Supervisor Code],[Day of Date]:
IF SUM([Commission A])>SUM([New Base Salary Current]) AND SUM([Commission A])<SUM([Second Base Salary Current ) THEN SUM([First Achievement])+SUM([Original Premium])*SUM([Commission A]-[New Base Salary Current])
ELSEIF SUM([Commission A])>SUM([Second Base Salary Current )AND SUM([Commission A])<SUM([Third Plan Base Salary]) THEN SUM([New First Achievement])+SUM([Second Achievement])+SUM([Original Premium])*SUM([Commission A]-[New Base Salary Current])
ELSEIF SUM([Commission A])>SUM([Third Plan Base Salary]) THEN SUM([First Achievement])+SUM([Second Achievement])+SUM([Third Achievement])+SUM([Original Premium])*SUM([Commission A]-[New Base Salary Current])
ELSE 0
END
}
I've tried this:
{ FIXED [Employee ID],[Area Code],[Supervisor Code],[Day of Date]:
CASE WHEN SUM`[Commission A]`>SUM`[New Base Salary Current]` AND SUM`[Commission A]`<SUM`[Second Base Salary Current ` THEN SUM`[First Achievement]`+SUM`[Original Premium]`*SUM`[Commission A]-[New Base Salary Current]`
CASE WHEN SUM`[Commission A]`>SUM`[Second Base Salary Current `AND SUM`[Commission A]`<SUM`[Third Plan Base Salary]` THEN SUM`[New First Achievement]`+SUM`[Second Achievement]`+SUM`[Original Premium]`*SUM`[Commission A]-[New Base Salary Current]`
CASEWHEN SUM`[Commission A]`>SUM`[Third Plan Base Salary]` THEN SUM`[First Achievement]`+SUM`[Second Achievement]`+SUM`[Third Achievement]`+SUM`[Original Premium]`*SUM`[Commission A]-[New Base Salary Current]`
ELSE 0
END
}
But apparently it didn't work and I don't know how to translate the Fixed syntax to Domo.
Anyone can help? I'd really appreciate it. Thanks a lot!
0
Comments
-
You might want to try something like this instead
CASE
WHEN `Commission A ` > `New Base Salary Current`
AND `Commission A` < `Second Base Salary Current`
THEN (`First Achievement` + `Original Premium`) * (`Commission A - `New Base Salary Current`)
WHEN `Commission A` > `Second Base Salary Current`
AND `Commission A` < `Third Plan Base Salary`
THEN (`New First Achievement`+`Second Achievement`+`Original Premium`) * (`Commission A - `New Base Salary Current`)
WHEN `Commission A` > `Third Plan Base Salary`
THEN (`First Achievement`+`Second Achievement`+`Third Achievement`+`Original Premium`) * (`Commission A - `New Base Salary Current`)
ELSE 0
ENDDomo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'1 -
I'm not sure of what type of vizualization you are trying to get but if it was a table card for example, the fixed function should not be a problem since you would be adding columns (Fixed fields) and the last would contain your beastmode that will automatically calculate and do the cuts depending on your columns (Grouping) selection. somehing like this
Employee ID Area Code Supervisor Code Day of Date Beastmode 55 789 1 2 x 22 987 3 2 y 13 456 5 2 z 55 789 1 3 z 22 987 3 3 x 13 456 5 3 y Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'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