This approach is taken directly from Chen, Sain, Guo (2012), and the data provided on the UCI Machine Learning Repository.
- Limit time to January 1st - December 1st.
- Add constaints to your search for
United Kingdom
,positive Quantity
,positive UnitPrice
, and a validCustomerID
| search Country="United Kingdom" Quantity>0 UnitPrice>0 CustomerID=*
- Calculate a
monetary
field by multiplyingQuantity
andUnitPrice