Hello,
I aggregated all the data received from the sales team and it gives me the quantity of bikes to produce for each combination of “Model”, “Colour”, “Fit option” and “Destination”.
The combination of those different metrics also lead to 1 unique SKU code.
How can I link those unique combination of dimensions to 1 unique SKU from dimension SKU?
Thanks for your help!
Ben
Best answer by Stef
Hi
The easiest way would be to make the SKU number a dimension (directly from the import). And then add the Model, colour etc as properties.
If that’s set-up, you can aggregrate the data either from the metric in your first screenshot like this
Metric [BY: SKU.Model, SKU.Colour, etc.]
Or you aggregrate it directly from the source of that metric (the TL list probably also has SKU code).
+12Hi
The easiest way would be to make the SKU number a dimension (directly from the import). And then add the Model, colour etc as properties.
If that’s set-up, you can aggregrate the data either from the metric in your first screenshot like this
Metric [BY: SKU.Model, SKU.Colour, etc.]
Or you aggregrate it directly from the source of that metric (the TL list probably also has SKU code).
+12Assuming that your second screenshot is a transaction list. If its not, then you’re already 90% there :)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
