avg of tshirt_quantity for each catergory

aditya28
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

  • Matias
    Matias Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Registered Posts: 12 Dataiker

    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

Setup Info
    Tags
      Help me…