Creating new field by summing two values from existing field
Noob here trying to not bother our internal devs…
I'm working on the chart below which is charting 3 join method values by month (noted in key below). I'd like to consolidate the Live Stream and PhoneAutomatedPin into one new value called Unassisted Entry such that the bar chart only shows Unassisted Entry and PhoneOperatorAssisted.
Thoughts on how I can tackle this?
Best Answers
-
Create a beast mode/calculated field that looks like this:
CASE WHEN joinmethod in ('PhoneAutomatedPin','LiveStream') THEN ‘Unassisted Entry’ ELSE joinmethod END
Drag this beast mode into your series instead of the joinmethod and the chart will do the rest.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
No problem. Happens all the time. If you can mark any answers as accepted, that will help others in the community.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Answers
-
Create a beast mode/calculated field that looks like this:
CASE WHEN joinmethod in ('PhoneAutomatedPin','LiveStream') THEN ‘Unassisted Entry’ ELSE joinmethod END
Drag this beast mode into your series instead of the joinmethod and the chart will do the rest.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
Mark - super appreciative of your help. I'm getting a syntax error and can't figure out why.
Thoughts?
0 -
It doesn't like the tics around Unassisted Entry. Use the same type of single quotes you have around LiveStream and PhoneAutomatedPin on the Unassisted Entry and it should work.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
A “duh” would be appropriate. Looks great.
Thank you!
0 -
No problem. Happens all the time. If you can mark any answers as accepted, that will help others in the community.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 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
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive