Count Set Analysis error

[didierodayo]

I need some help working out what is wrong with this expression: I am getting error in expression.

I am trying to Count the contact numbers that appear more than once on the contact field in the same table.

count({<count(distinct[MOBILE_PHONE_NB]){'>1'}>}[MOBILE_PHONE_NB])

[Anonymous]

Hi Didier,

Could you please provide more details about how do you want to display the data?

Regards,

-- Karla

[swuehl]

The set expression syntax is not correct.

Have a look at

A Primer on Set Analysis

and try maybe something like

=Count({<[MOBILE_PHONE_NB] = {"=Count([MOBILE_PHONE_NB])>1"}>} DISTINCT [MOBILE_PHONE_NB])

[trdandamudi]

Attached is a sample app and hope this helps you...

[didierodayo]

    hi all,

as you can see from this table I suspect there is some fraudulent activity.

- student 1 and student 11 are using the same phone number

- student 5 and 10 have similar number (the first 7 digits are the same)

I need the set analysis script to Identify similar(the first 7 digits are the same) or same numbers where the claimant_id is different. and return the phone number (s).

I hope this clarifies. Thanks a lot

Claimant_ID	CLAIM_ID	MOBILE_PHONE_NB
1	255	99784561
2	266	77542168
3	267	68542879
4	268	11789562
5	269	99784573
6	270	33535565
7	271	74145428
8	272	94852630
9	273	25893754
10	274	99784562
11	275	99784561

[didierodayo]

Hi Thirumala,

I can't see your attachement. I have added a new documents to clarify what I need. could you resend the attachment please.

Thanks

[trdandamudi]

I modified according to your logic and this will list out where the phone numbers are same:

[didierodayo]

Hi Thirumala,

Where is your attachment? If you are having issues attaching maybe email it to me  esterdid@hotmail.com

Thannks

[trdandamudi · Accepted solution]

I am not sure why you are not able to see the attachment... I do not have access to send emails..Any have here are the steps and hope this will be helpful......

Below is script:

Table:

Load  * Inline [

Claimant_ID,CLAIM_ID,MOBILE_PHONE_NB

1, 255, 99784561

2, 266, 77542168

3, 267, 68542879

4, 268, 11789562

5, 269, 99784573

6, 270, 33535565

7, 271, 74145428

8, 272, 94852630

9, 273, 25893754

10, 274, 99784562

11, 275, 99784561

];

Now Create a Pivot Chart as below:

Dimensions:

Claimant_ID

MOBILE_PHONE_NB

Expressions:

=count({$<MOBILE_PHONE_NB={"=Count(MOBILE_PHONE_NB)>1"}>}Claimant_ID)