Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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