avg of tshirt_quantity for each catergory

[aditya28]

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.

[MatiasL]

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!

Regards,

Matias