topic Do you use lag(x)? in Discussions

Do you use lag(x)?

hogi — Sat, 11 Jan 2025 05:54:29 GMT

... seems that this is no longer possible:

tested with JMP18.1.1

JMP17:

Jeff_Perkinson — Fri, 10 Jan 2025 22:13:19 GMT

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

hogi — Sat, 11 Jan 2025 08:51:14 GMT

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 — Sat, 11 Jan 2025 08:33:41 GMT

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

hogi — Sat, 11 Jan 2025 06:52:16 GMT

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

jthi — Sat, 11 Jan 2025 06:59:29 GMT

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

hogi — Sat, 11 Jan 2025 08:48:48 GMT

Good point, thanks @jthi for digging deeper.

I never paid attention and noticed the 2 ways formula editor displays optional arguments: