Creating New Columns in Beastmode
Hi all,
Is it possible to create new columns in beastmode? I have a dataset that has Unique IDS, Date and Type of Contact made with a lead. Some task types are more valuable than others so what I want to do is calculate how many non-valuable task types it takes before reaching 1 valuable task type for EACH unique ID.
I'm very new to DOMO so I can't give sample code but I've written the concept below:
WHEN [tasktype] = [valuable task type name] AND [valuable task type date] <> [Firstdate a task was created] THEN Count # of non-valuable tasks it takes before first contact and create a new colomn for each unique ID
Ultimately -- I just need the syntax for creating new columns, if at all possible. I hope this makes sense. I appreciate the help in advance!
Comments
-
Hi,
If I correctly understand, you want to dynamicly create X numbers of columns in a beast mode? Is that right?
If so that is not possible, because a beast mode represents a new calculated column by it self.
Hope this helps. Don't hesitate to ask if you have any questions.
Ricardo Granada
MajorDomo@Lusiaves
**If the post solves your problem, mark it by clicking on "Accept as Solution"
**You can say "Thank you" by clicking the thumbs up in the post that helped you.0 -
It sounds like you'd require beast mode to link aggregated data to a particular row of data to make the comparison and that would take some nesting logic. This kind of looping is best done in a SQL dataflow or in a custom app. Beast modes can't nest like this at present.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
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
- 88 SQL DataFlows
- 555 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 567 Beast Mode
- 9 App Studio
- 27 Variables
- 577 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 22 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 91 Manage
- 88 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive