avg of tshirt_quantity for each catergory
Options
aditya28
Dataiku DSS Core Designer, Registered Posts: 1 ✭
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.
Tagged:
Answers
-
MatiasL Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Registered Posts: 12 DataikerOptionsHi @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!
Regards,
Matias