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; } } }

Implement Counter in a dataset

tbps

Hi all,

I have the following problem: In my dataset there is a car accelerated 10 times. Between the accelerations there is always a deceleration phase.

I managed to figure out the acceletation phases by a formula. This column now shows 1 at acceleration and 0 at all other times. For further chance to sort the data I would like to have the number of the acceleration - so everytime when accleration is recognized then a counter shall be activated. This way, I should easily detect accelerations 1-10 in my dataset.

I hope someone can help on this issue!

Accepted answers

txnelson

Attached is a data table with a few different formula columns that count the Accelerations in different ways. I was not sure what the specific details of the counting are, thus the multiple methods.

sums.jmp

All comments

You could check if your accelleration tag is different than the row before it, something like this:

Names default to here( 1 );

dt = New Table( "Position Data",
	Add Rows( 1000 ),
	New Column( "Time", Numeric, "Continuous", Format( "Best", 12 ), 
		Formula( Row() ) ),
	New Column( "Position", Numeric, "Continuous", Format( "Best", 12 ),
		Formula( Sine( :Time / 20 ) ) ),
	New Column( "Speed", Numeric, "Continuous", Format( "Best", 12 ),
		Formula( Dif( :Position ) ) ),
	New Column( "Acceleration", Numeric, "Continuous", Format( "Best", 12 ),
		Formula( Dif( :Speed ) ) ),
	New Column( "Is Accel", Numeric, "Continuous", Format( "Best", 12 ),
		Formula( ( :Acceleration - Lag( :Acceleration, 1 ) ) > 0 ) ),
	New Column( "Start Accel", Numeric, "Continuous", Format( "Best", 12 ),
		Formula( If( :Is Accel == 1 & Lag( :Is Accel, 1 ) == 0, 1, 0 ) ) ),
	New Column( "Accel Count", Numeric, "Continuous", Format( "Best", 12 ),
		Formula( Col Cumulative Sum( :Start Accel ) ) )
);

dt << Graph Builder(
	Size( 522, 627 ),
	Show Control Panel( 0 ),
	Variables(
		X( :Time ),
		Y( :Start Accel ),
		Y( :Acceleration ),
		Y( :Speed ),
		Y( :Position ),
		Overlay( :Accel Count )
	),
	Elements( Position( 1, 1 ), Line( X, Y, Legend( 66 ) ) ),
	Elements( Position( 1, 2 ), Line( X, Y, Legend( 67 ) ) ),
	Elements( Position( 1, 3 ), Line( X, Y, Legend( 68 ) ) ),
	Elements( Position( 1, 4 ), Line( X, Y, Legend( 69 ) ) ),
	SendToReport(
		Dispatch(
			{},
			"400",
			ScaleBox,
			{Legend Model(
				67,
				Base( 0, 0, 0 ), Base( 1, 0, 0 ), Base( 2, 0, 0 ), 
				Base( 3, 0, 0 ), Base( 4, 0, 0 ), Base( 5, 0, 0 ),
				Base( 6, 0, 0 ), Base( 7, 0, 0 ), Base( 8, 0, 0 )
			), Legend Model(
				68,
				Base( 0, 0, 0 ), Base( 1, 0, 0 ), Base( 2, 0, 0 ),
				Base( 3, 0, 0 ), Base( 4, 0, 0 ), Base( 5, 0, 0 ),
				Base( 6, 0, 0 ), Base( 7, 0, 0 ), Base( 8, 0, 0 )
			), Legend Model(
				69,
				Base( 0, 0, 0 ), Base( 1, 0, 0 ), Base( 2, 0, 0 ),
				Base( 3, 0, 0 ), Base( 4, 0, 0 ), Base( 5, 0, 0 ),
				Base( 6, 0, 0 ), Base( 7, 0, 0 ), Base( 8, 0, 0 )
			)}
		),
		Dispatch(
			{},
			"400",
			LegendBox,
			{Legend Position(
				{66, [0, 1, 2, 3, 4, 5, 6, 7, 8], 67, [-1, -1, -1, -1, -1, -1, -1,
				-1, -1], 68, [-1, -1, -1, -1, -1, -1, -1, -1, -1], 69, [-1, -1, -1,
				-1, -1, -1, -1, -1, -1]}
			), Position(
				{0, 1, 2, 3, 4, 5, 6, 7, 8, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1,
				-1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1}
			)}
		)
	)
);

Edited to fix minor bug.

txnelson

Attached is a data table with a few different formula columns that count the Accelerations in different ways. I was not sure what the specific details of the counting are, thus the multiple methods.

sums.jmp

tbps

Hi Jim,

solution 2 would just be perfect.

tbps

Hi ih,

this is how I would like to set it up - I am not sure how I can set this up for my dataset as I am fairly new to the program. But meanwhile I worked out something that works (circuitous).

Thanks anyway.

txnelson

Your response was in a "future tense" leading me to wonder if you are expecting an additional response, with the formula for the second Counts case. If you are waiting for such a response, the answer is that the formula you want is in the column in the data table that was attached to my last response.

tbps

Hi Jim, I realised this later on. Thanks.