Looking for some advice here:
I have product, booking_weekly_date, qty, revenue, cost, 2 more numerical variables
Initially I clustered using k means for different products based on qty, revenue, cost, other 2 numerical values by aggregating all the numerical values at the PID level
but if we need to bring the booking_weekly_date then the aggregation of all the numerical columns will be at (PID, bookingDate). what will the cluster convey? will it capture seasonality pattern of the product. Appreciate any help?