My in my case one Item assigned with OrderID may have quantity more than 1. For example one item with 2 quantity has been ordered
My fields are
1) date flag which have delivered and dispatched
2) Quantity
3) orderID
4) date field as logistic_date
however i am able to count order ID using flag and able to plot it on weekly basis.
kindly help me to figure out
How should I calculate sum of quantity with different flag like delivered and dispatched on weekly and daily basis?