Waterfall Analysis Assistance

Question

Hi all,

I am working on a project for my team where they initially request for a top 5 of a current process but now are requesting a full series of the process I am completing within my tool container.

Process:

1. Remove RecordID 1

2. Remove Duplicates

3 Count for it and ID it.

4 Remove Record ID 1 and 2

5. Steps 2-3 again

Now the thing is i have to do this to about 100 ID's is there an easier way to do this, all while ID'ing the results?

I am super confused now but what I need to do is dynamically add a +1 to the record ID for each new ID generated.

Record IDID111+221+2+331+2+3+......

Thanks!

waterfall example.yxzp

Waterfall Example.xlsx

jgarcia0417 · Answer

Hi,

Not sure if that answers my workflow question, incoming RecordID data is a string that is used to create a unique grouping for Player Positions

I cannot add using multi-row formula

My goal is to do the following filter out record ID 1, then remove duplicates of Teams, then count total rows of data, then name label that row of data ID 1

RecordIDID111+221+2+33

id like to do this dynamically until I run out of values in RecordID

im sure its one of the multi tools but im not great at it.

Thanks!

Garabujo7 · Answer

Hello @jgarcia0417 ,

That's a job for the multi-row formula.

That goes from here:

To the ID.

This example shows one new field, you could use an existing one and add up.

Gabriel