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!

Find more posts tagged with

Comments

RGranada

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.

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.