More Help on this assignment.

Hi, guys. I'm the budget allocation guy on last Wednesday if you remember. I need more help on the workflow. Now, I'm able to allocate the budget thanks to the fraction method given by Mr. Gawa. But currently, I want my workflow to be able to allocate in more specific numbers aside fractioning. So, I would like to ask how can I modify the workflow to achieve this result?

The current result is like this

I want it to be like

NewP2.yxmd

Workflow

Help

Accepted answers

Eakdanai

NVM, I finally did it!

All comments

Eakdanai

NVM, I finally did it!

Gawa

@Eakdanai

This problem need to solve indeterminate equation> One way is to use Optimization tool.

As this is your assignment, I cannot share my solution directly but I can advise:

- Dividing values by 50,000(if round value to $50,000 wise), and simplify the value

- Define the variables and its constraints and range of its value

(target value seems within $50,000-$250,000, that is equal to 1-5 in range configuration).

If you are not familiar with Optimization tool, please start to study about it. I think you can find good resource in Alteryx Community or simply Google search.

A part of configuration of Optimization tool for your reference.

Eakdanai

Thanks for your useful guidance yet again. Even though I already figured it out myself. I will try to see if I can apply ur suggestion to my workflow.

Gawa

@Eakdanai

If allowed, can you tell me how did you realize it? I could not come up with idea other than using Optimization tool.

Eakdanai

Well, I simply combine product and marketing channel into one table, and assign each cells with the weight scoring from WDM model. Then use formula to multiply each score by 10000 to get the actual budget. Before I calculate the sum into Total Record/Column.

P2Final.yxmd

Gawa

As I'm not familiar with WDM model, I'll look into it more. Thanks.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703