Lastest week count

[Abhi999]

Could some one help me on below query.

I want to count of orders weekly based on max in date field.

[tresesco]

You have given not much information. With that; you may try something like:

Dim : Week

Exp : FirstSortedValue(Aggr(Count(Distinct OrderID), Week, Date), -Date)

[Abhi999]

Hi Tresesco, I am using KPI to show latest week , based max available date. 

Ex: I have data only upto last Monday, so I want calculate orders of last week. 

[tresesco · Accepted solution]

If you have a week field(if you don't, create it in the script using week()), you can try like:

Count({<Week={'$(=Max(Week))'}>}OrderID)