Survey banner
Switching to Dataiku - a new area to help users who are transitioning from other tools and diving into Dataiku! CHECK IT OUT

avg of tshirt_quantity for each catergory

Level 1
avg of tshirt_quantity for each catergory

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.

0 Kudos
1 Reply

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!






0 Kudos