how to display the number of times a data combination appears?

[#1]

Hi, how to display a particular data combination, across multiple fields, and the number of times each combination appears in the dataset? example below. Thanks.

date	Site	Person	Count
Apr-14	AQ	Rachel	3
Apr-14	HU	ACH	7
May-14	FT	gklim	12

[SunilChauhan]

use

rowno() as row in your table

and use row into your table above and use straight table

and hide row field using Presentation-> select row expression and check hide

hope this helps

[#3]

Hi, does rowno() count the number of rows with the same records?

[Anonymous]

Atually I didn't understood your point,

But taking Date, Site and Person as dimension and

count(date&site&person) will also give the count of combination of records.

If it do not helps , please elaborate more abt your req

Regards

Nitin

[#5]

Basically I want to count the number of duplicate rows for each distinct combination. I want to use recno function but I don't know which part of the script to write it. Thanks.

[#6]

Hi Rachel,

Just the count(date&site&person) will give the number of rows for the combination. you wouldn't need to use Recno.

Thanks,

Prabhu

[its_anandrjs]

If you have any sample data then share it, this will help a lot.

[#8]

HI Rachael,

You can directly use count for counting the combination value either count(Site) or count(Person) will give you same result till they are in range of date.