nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Component Count Incrementing

dkraeuter_sunne

I have data where a certain number of parts are used on a component before it is replaced. At the point when the component is replaced, the part count is reset to 1. I would like to create a column that increments the component count each time the part count is reset to 1. How would I do this?

I attached a picture of the part count over time to help with understanding how the data looks. Time vs Part Count.JPG

Accepted answers

dkraeuter_sunne

If( Row() == 1,
	x = 1,
	If( :Part Count == 1,
		x++,
		x
	)
);
x;

All comments

txnelson

This will be very easy to do, if you can tell me what is the indicator that the Component has replaced?

dkraeuter_sunne

The indicator that the component has been replaced is when the part count reverts to 1.

Is this what you needed?

txnelson

Here is a formula that will work

If( :Part Count == 1 | Row() == 1,
	x = 1,
	x
	++);
x;

ThuongLe

It's quite simple. The steps are this:

Sort Time column ascending
Create new column "ComponentCount" with below formula:

New Column("ComponentCount", Numeric, Continuous, Formula(
      If(Row() == 1, 0,
         :PartCount == 1, Lag(:ComponentCount, 1) + 1
   )
)

dkraeuter_sunne

If( Row() == 1,
	x = 1,
	If( :Part Count == 1,
		x++,
		x
	)
);
x;