Why do you always have to select distinct on add data aggregates?

Avatar

Avatar
Level 1
Glen_Leavitt
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile

Avatar
Level 1
Glen_Leavitt
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile
Glen_Leavitt
Level 1

06-06-2014

Seems to me if you group by all the dimensions and aggregate the measures you shouldn't have dupes?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 1
GMSPrem-lAb0Gw
Level 1

Likes

0 likes

Total Posts

14 posts

Correct reply

3 solutions
Top badges earned
Validate 1
Applaud 5
Affirm 3
Affirm 1
View profile

Avatar
Validate 1
Level 1
GMSPrem-lAb0Gw
Level 1

Likes

0 likes

Total Posts

14 posts

Correct reply

3 solutions
Top badges earned
Validate 1
Applaud 5
Affirm 3
Affirm 1
View profile
GMSPrem-lAb0Gw
Level 1

11-11-2015

Yup! Glen you are right .. We always use distinct to avoid duplicates while grouping.

Answers (0)