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

Do you use lag(x)?

hogi

... seems that this is no longer possible:

tested with JMP18.1.1

JMP17:

Accepted answers

hogi

The good thing:
It's not a general issue of "Lag"

... it seems to be caused by:

When I generate the Formula this way, the entries are empty.
When I create a new column and add the formula afterwards, the values are calculated.

added: video with different ways to generate the formula column

new formula column: add lag via click -> fail
new formula column: add lag manually -> fail
new formula column: delete code and write again -> fail
new column -> add formula manually -> works
new column -> add formula column via click and write (like #2) -> works

jthi

Seems like JMP will incorrectly evaluate the "missing" argument to Empty()

// Transform column
Data Table("Big Class") << Apply Formula(
	Columns(:weight),
	Formula(Lag(:weight, Empty())),
	Output(New Formula)
);

If you use Lag under Row this doesn't happen as it uses other method to create the column

// New formula column: Lag[weight]
Data Table("Big Class") << New Formula Column(
	Operation(Category("Row"), "Lag"),
	Columns(:weight)
);

Edit: And it does happen with other functions too (at least with Dif but there could be other)

// Transform column
Data Table("Big Class") << Apply Formula(
	Columns(:weight),
	Formula(Dif(:weight, Empty())),
	Output(New Formula)
);

All comments

Jeff_Perkinson

Seems to work fine in all the versions I tried, including 18.1.1.

2025-01-10_17-05-01.034.png

hogi

Ok, good.

And kind of strange ...

So, it's neither 100% gone - nor 100% working.
what makes the difference ?

PC vs. Mac?
... I will check my preferences - and compare with more colleagues.

hogi

The good thing:
It's not a general issue of "Lag"

... it seems to be caused by:

When I generate the Formula this way, the entries are empty.
When I create a new column and add the formula afterwards, the values are calculated.

added: video with different ways to generate the formula column

new formula column: add lag via click -> fail
new formula column: add lag manually -> fail
new formula column: delete code and write again -> fail
new column -> add formula manually -> works
new column -> add formula column via click and write (like #2) -> works

hogi

I submitted a ticket to JMP support: TS-00182750
let's see ...

jthi

Seems like JMP will incorrectly evaluate the "missing" argument to Empty()

// Transform column
Data Table("Big Class") << Apply Formula(
	Columns(:weight),
	Formula(Lag(:weight, Empty())),
	Output(New Formula)
);

If you use Lag under Row this doesn't happen as it uses other method to create the column

// New formula column: Lag[weight]
Data Table("Big Class") << New Formula Column(
	Operation(Category("Row"), "Lag"),
	Columns(:weight)
);

Edit: And it does happen with other functions too (at least with Dif but there could be other)

// Transform column
Data Table("Big Class") << Apply Formula(
	Columns(:weight),
	Formula(Dif(:weight, Empty())),
	Output(New Formula)
);