Skip navigation

1 Reply Latest reply on Feb 7, 2019 4:21 AM by Tauseef Firdausi

Order Count in single week (>5)

Dattatray Vanti Feb 7, 2019 3:20 AM

Dear all

As per below screen shot Need you help to modify the code

Objective is calculate in given week how many order has been generated which having ">5"

Currently I'm getting in a month how many order have taken i wanted to break it into weeks

PC Order_SM_10.4 (1).twbx 11.8 MB

1. Re: Order Count in single week (>5)

Tauseef Firdausi Feb 7, 2019 4:21 AM (in response to Dattatray Vanti)

Hello Vanti,

Just add order date in fixed LOD that you have used in your calculation.
Refer Below calculation

{fixed [Salesman Code],[Order Date]:
countd(
if {fixed [Order Date],[Salesman Code],[Cluster]:countd([Unique Bill])}>5
then [Order Date]
end
)}
Like Show 0 Likes(0)

Actions

More Like This