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
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.
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?
So we have to use the group by targeting dimension in addition to grouping the columns everytime? If so why?
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.