aggr into script

[surajdhall]

Hi Experts,

I have an aggr expression that i want to move into the script to improve the performance, but i am not sure.

The expression is in the Trend dimension column in the pivot tab.

Could you please help.

[MK9885]

Hi Sunny,

I've quite similar request. I want to load count distinct ID as new field in Script.

I want to bring all ID' plus also bring count distinct ID's

I tried Group by but didn't seem to work in front end a I'm using Count against many dimensions in different charts.

Hope i'm clear in requesting my query...

Can you please suggest?

[sunny_talwar]

I would need to see data... just like surajdhall did

[MK9885]

The Data is as always confidential data plus the size of the data is 500M+ records.

I only need to count distinct id based on different dimensions...

Can I do..

Load

ID,

Count(Distinct(ID)) as CountID

Resident Table

Group by ID, Dimension1, dimension2, Dimension3 etc....?

[sunny_talwar]

It should work.... if you can mock up (again just like how surajdhall did... I am sure this is not his complete data and is not the actual data).... Brother you need to make some efforts if you need helpful responses.... just giving bits and pieces of information will not get you anywhere

[MK9885]

Ok, I'll try to make an effort and let you know

Thanks.

[sunny_talwar]

Sounds like a deal