Registered users can ask their own questions, contribute to discussions, and be part of the Community!
I want the avg of each tshirt_category for each order of quantity ordered.
for eg in my table if a customer has ordered White T-Shirt M, then in the avg column it should have the avg of total White T-Shirt M ordered.
Hi @aditya28 ,
You can simply use a Group By recipe and select the 'tshirt_category' column as the grouping column, then you can select the 'average' step as the aggregation for the 'tshirt_quantity_avg'
Quick example below attached, with different columns but same logic.
Let me know if it looks good that way and thank you!
Post a Question