Your achievements

0% to

Tip / to gain points, level up, and earn exciting badges like the new

Adobe Campaign Standard

Submissions are now open for the 2026 Adobe Experience Maker Awards

Apply Now

This conversation has been locked due to inactivity. Please create a new post.

SOLVED

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

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

1.2K

1 Accepted Solution

Correct answer by

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

925

Jump to reply

1 Reply

Correct answer by

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

926

Jump to reply

Related Conversations

How to get refresh token in ACS Solved

2.5K

Exporting multiple query counts into one CSV file Solved

587

696

Format Count to thousands in Workflow Param. Solved

334

Adobe Campaign Standard: Update Delete data inside an Audience Solved

602