Unique product ids bought | Community
Skip to main content
catalinmartin
catalinmartin
Level 2
November 6, 2018
Solved

Unique product ids bought

  • November 6, 2018
  • 1 reply
  • 1138 views

Hi guys,

I've created a metric showing me the unique products ids from an order. I have used approx count distinct and works as expected if I user Order id as dimension & this new metric.

Now, I would like to know for a specific month, for example, number of unique product ids bought. Do you have any suggestions on how the definition of this new metric should look like? The same metric will return less volumes than expected (something like 50% less).

Any hint will be much appreciated.

Thank you in advance.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Gigazelle

    Yeah, if you put order IDs inside approximate count distinct, then use that calculated metric against a month dimension, that should give you what you're looking for.

    1 reply

    Gigazelle
    Adobe Employee
    GigazelleAdobe EmployeeAccepted solution
    Adobe Employee
    November 9, 2018

    Yeah, if you put order IDs inside approximate count distinct, then use that calculated metric against a month dimension, that should give you what you're looking for.

      Terms & ConditionsAccessibility statement

      Loading footer...