Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
SOLVED

Unique product ids bought

Avatar

Level 2

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.

capture1.JPG

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.

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

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.

View solution in original post

1 Reply

Avatar

Correct answer by
Employee Advisor

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.