populate a new column based on criteria from existing columns

Hi,

I need to populate a new column based on criteria from existing columns. In this example, I would like this data

converted to this.

Where the new column "Result Denominator' is populated with the value against metric 'Total Hours' for that Agent on that day. I'm a complete newbie. Can anyone advise which tool/tools i need? Thank you

result_denom.yxmd

Developer

Transformation

Preparation

Interface Tools

Accepted answers

Ruby2

I think I figured it out. Thanks for your help

result_denom_solution.yxmd

All comments

JosephSerpis

Hi @Ruby2 I mocked up a workflow that produces the output you describe. Let me know what you think?

Column_14082020.yxmd

Ruby2

That was fast! 😄 Thank you so much!

Drussek

Hope this is it.

Next time please attach your data - it is easer and faster to prepare a solution

20200814_2.yxmd

Ruby2

On closer inspection, David, I believe this assumes that the data will always have Total Hours as the last record per agent per day. That was the case in my mock up data but won't be in real life. The table has millions of records. I guess I could some kind of count to assign a unique record ID to each agent for the day but couldn't sort Total Hours to be at top as it is not the last metric alphabetically. Is there any other way?

Ruby2

Thank you. I will make sure I post a dataset in future. I can see now that pictures just create more work for people. Thank you for your solution but it doesn't give me quite the result I need. I need that Result Denominator to show against every record. I will post up a dataset.

Ruby2

I think I figured it out. Thanks for your help

result_denom_solution.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703