Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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
Hi, does rowno() count the number of rows with the same records?
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
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.
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
If you have any sample data then share it, this will help a lot.
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.