Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'm having trouble calculating a count per week. See image below. I want the week count to be the total for the week regardless of the "When Verified" dimension. So for every row with 7/2/2017 the value would be 2923. I've tried numerous expressions using set analysis etc. but cannot get this to work. Thanks in advance for any assistance.
The latest attempt was the following: Aggr(count([Order#]),Weekstart(Collected))
Unfortunately, you cannot use a calculated dimension in Aggr() function. May be create a new field in the script like this
WeekStart(Collected) as WeekStart_Collected
and then try this
Aggr(Count([Order#]), WeekStart_Collected)
or this
Aggr(NODISTINCT Count([Order#]), WeekStart_Collected)
Unfortunately, you cannot use a calculated dimension in Aggr() function. May be create a new field in the script like this
WeekStart(Collected) as WeekStart_Collected
and then try this
Aggr(Count([Order#]), WeekStart_Collected)
or this
Aggr(NODISTINCT Count([Order#]), WeekStart_Collected)
Thanks Sunny! That was it. I changed it to load it specifically and works correctly. I did need the NODistinct as well.
Thanks again.