Expand my Community achievements bar.

Group by targeting dimension element

Avatar

Level 7

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

6 Replies

Avatar

Community Advisor

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 7

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

Community Advisor

Hi @Sanjana12

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

Regards

Avatar

Level 7

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

Avatar

Administrator

Hi @AkshayAnand

Could you please help @Sanjana12 further with their query?

Thanks!



Sukrity Wadhwa

Avatar

Employee Advisor

Hi @Sanjana12 -

 

The "group by targeting dimension element" refers to grouping data in a data set based on the values of specific columns or dimensions. 

 

If you see the same number of results as before after grouping by the targeting dimension element, it may indicate that the grouping is not being applied correctly. It's possible that the values in the grouping column are not unique, or that the data is not being grouped as expected.

By grouping the data in this way, you can calculate aggregates such as the mean, sum, or count for each subgroup. This can provide insights into the behavior of different audience segments, which can be useful for optimizing your marketing campaigns and website design.