How to use max(Date) in a chart

[tappij2012]

Hi,

I'll want to use a max(Date) for the charts like below.

Red circle shows all the data, but I want only to see the total of max date. In this case it's 2 instead of 5.

This has to be the same for the Green circle.

[jonathandienst]

Something like

Count({<Date = {"$(=Max(Date))"}>} customer)

[tappij2012]

Thanks this works, but I've use an other name then Date, now I'll don't know what to change.

Where do I put the name Datum instead of Date?

[arvind1494]

in a set expression

{<Date={$(=max(Date))}>}

[tappij2012]

It doesn't recognize the date format I'll want to use.

How can I put this format (yyyymmdd) in this formule: count({<Date={$(=max(Date))}>}customer)

[sunny_talwar]

May be this

Count({<Date={"$(=Date(Max(Date), 'YYYYMMDD'))"}>} customer)

[jonathandienst]

Robin Tappij Gielen wrote:

Thanks this works, but I've use an other name then Date, now I'll don't know what to change.

Where do I put the name Datum instead of Date?

Count({<Datum = {"$(=Max(Datum))"}>} customer)