Count if equal to expression

[eddyg]

Is it possible to replace the static date value in the following formula with a dynamic expression that computes the max date?

count({<date={'2022-03-01'}>} order)

here is the expression to get max date: Date(max(date),'yyyy-MM-dd')

[MartW]

yes,

you can use something like count({<date={"$(=max(date))"}>} order)

this replaces the static value of 2022-03-01 to the max date value in your model

if this worked please accept this answer as the solution and give it a like