Group by targeting dimension element

[Sanjana12]

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

[AkshayAnand]

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.

Regards

[Sanjana12]

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?

[AkshayAnand]

Hi @Sanjana12

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

Regards

[Sanjana12]

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

[Sukrity_Wadhwa]

Hi @AkshayAnand, 

Could you please help @Sanjana12 further with their query?

Thanks!