I have transaction data and I am trying to find the average of such numbers. The data is laid out where each product bought is a row - i.e. if a transaction has three items purchased that transaction will cover three rows (and each of these rows will have qty of item bought, how much the item was purchased for, etc). I wanted to do some simple calculations such as average number of items purchased and average amount spent per purchase, but was struggling with how to lay this out in Alteryx.
Happy to clarify anything and really appreciate your help!