Aggr for max date and count IDs

berndjaegle — Thu, 21 Apr 2022 15:09:31 GMT

Hi guys,

I need a simple count but with the aggr function.

What I need:

Last Date of an Import Run --> and Counting the items "LeistGUID" per MaxDate.

What works:

Aggr( Max(Importdatum), LI_Quellsystem) --> gives me the max dates per Quellsystem.

and even showing the "LeistGUID" as a dimension.

Question:

How can I count the "LeistGUID" per Max(Importdatum).

My try:

count(Aggr( Max(Importdatum), LI_Quellsystem, LI_LeistGUID) )

Does count on all LI_LeistGUID, but count only on max is needed.

Thanks for you help.

BR,

Bernd

topic Aggr for max date and count IDs in App Development