How can I successfully create a segment where I can get only SKUs which has more than 10 units ordered in a visit?

[ltaparia]

Hi Everyone,

I am trying to get all SKUs which has more than 10 units sold in a visit. Here is report with segment definition which is giving wrong output:

I understand the fact that product variable could have multiple SKUs with varying quantity in an order hit and only all hits which qualifies my condition of the segment ( that is unit > 10) qualifies for this segment.

This brings other SKU’s which have units lesser than 10. How can I successfully create a segment where I can get only SKUs which has more than 10 units ordered in a visit? @Urs_Boller Could you please help?

[Asheesh_Pandey]

@ltaparia try using distinct count feature https://www.youtube.com/watch?v=7A00dkA2cPI

[ltaparia]

@Asheesh_Pandey Thanks for the response. but distinct count only works for dimension. Isn't it? How can I use it for "Units" Metric?

[Urs_Boller]

I don't think there is a way in analytics to get the sum of the metrics within segments. The missing part is the ability to use "calculated metrics" within a segment which would allow to do the math.
meanwhile (if it is important), you could change the tracking implementation and add a counter "client side"...

[BrianTophamAdobe · Accepted solution]

Since the product string is a "List Variable" (a variable that can hold more than one value at a time), such a segment will return the full product string for any production string that had at least one product with more than 10 units. So, there is not a way to create such a segment and ONLY get units over 10 back, unless the product string ONLY contained that single product with more than 10 units, and had no other product passed.