Ignore one dimension while doing the count

[harisri]

Hello Everyone,

Good day!!

i have data like below,.

i would like to do count of ID by ignoring the "App ID" column in script level.

For example, in below if i write code has Count(ID) by group by ID then for ID 250,400 i will get count has 2 and for remaining IDs will get count has 1. But here i would like to ignore the App ID column while doing the count then i will get count has 1 for ID 250.

And this i wants achieve without using distinct , because in my data there are some cases where i have same ID for 2 Names (ex:- Id 400).

Request you to help and let me know if you need any other information

ID	Name	APP ID
250	Hari	102
250	Hari	105
350	Sai	103
400	Sat	104
400	Sham	109

[GaryGiles]

Not sure that I totally what you are asking.  Some of it depends on how you are going to use the count and what other dimensions are involved, but you may want to start with including the Aggr() as part of  your expression.  Something like this:

=count(aggr(count(ID),Name))

[andykrst]

if in script level you mean in a load script,

why not you just count distinct the name then, or

usually ID should be Unique , or at least you can create a new ID with concatenating ID and Name , and count distinct that new ID..

hope this help. . 

AK