Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Unique product ids bought

Avatar

Avatar
Validate 1
Level 2
catalinmartin
Level 2

Likes

7 likes

Total Posts

21 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
catalinmartin
Level 2

Likes

7 likes

Total Posts

21 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
catalinmartin
Level 2

06-11-2018

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.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Coach
Employee
Gigazelle
Employee

Likes

468 likes

Total Posts

1,947 posts

Correct Reply

739 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

468 likes

Total Posts

1,947 posts

Correct Reply

739 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
Gigazelle
Employee

09-11-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.

Answers (0)