among individuals counting activities between events

jbuszin

Could use some advice on how you would do this in alteryx. Below is data from a single person. The first column is a marker between events (for example, has a baby, and this person had 3 babies). The second column is the number of activities that happened between events. Sticking to the example, that lets call them doctor appointments. So, this person had 14 doctor appointments before baby 1, 26 after baby 1 and before baby 2, and 14 after baby 2 and before baby 3. Note the dataset actually has many individuals (with a unique ID) in there with different numbers of babies.

I need a third column that can tell me the total number of appointments between babies and I'm totally blanking on this.

Had Baby	# appointments
0	1
0	0
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
1	0
0	1
0	0
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
1	0
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
0	1
1	0

AbhilashR

@jbuszin - attached is my attempt to compute the sum of appointment before each baby

EDIT - I have reattached a modified version of my solution to accommodate for multiple ID's in your data.

sample.yxmd