Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Could some one help me on below query.
I want to count of orders weekly based on max in date field.
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)
You have given not much information. With that; you may try something like:
Dim : Week
Exp : FirstSortedValue(Aggr(Count(Distinct OrderID), Week, Date), -Date)
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.
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)