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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!

Group by targeting dimension element

Avatar

Level 5

I have a scenario where I have to calculate aggregates on some recipient columns. I'm grouping all the columns and then aggregating on them.That's generating some results.But what is group by targeting dimension element? Because when I'm doing that, it's generating the same number of results as before. Please help

5 Replies

Avatar

Level 3

Hi @Sanjana12

As you are targeting your recipient schema, hence those become your targeting dimensions. So when you are doing GroupBy Targeting Dimension it is giving the same result are your are getting previously by your methods.

AkshayAnand_0-1670237906184.png

Regards

Avatar

Level 5

So do we need to manually group and still add group by targeting dimension? Or we can simply group the columns and do away with group by targeting dimension element?

Avatar

Level 3

Hi @Sanjana12

You can group the columns with group by targeting dimensions and proceed with your results for further operations.

Regards

Avatar

Level 5

So we have to use the group by targeting dimension in addition to grouping the columns everytime? If so why?