R
Rum
Hi,
I have a excel data set with 7000 rows and about 10 columns.
Example: Columns are:
‘Login Id’; ‘Int Vs Ext’; ‘TA’; ‘Protocol’; ‘Site #’
Under all these heading of columns are multiple records:
Example: If there are 20 unique login ids each appears multiple times. So is
the case with Int Vs Ext, TA, Protocol, Site #
I am trying to find:
1. Average number of ‘protocols’ per ‘login id’
2. Average no of ‘sites #’ per ‘login id’
I have been trying to do this using a pivot table and I get a count of all
the protocols that correspond to a Login Id. This is a reflection of how many
times a protocol appears in the data set. But I multiple entries of the same
protocol to be counted as one. This way if a login Id had for example 100
protocol entries, I wish to get how many of those 100 protocol entries are
unique. Example: if XXX appears 20 times, YYY appears 30 times, ZZZ appears
50 times in protocol records I need it to be counted XXX, YYY, ZZZ each once
making it a unique count of 3.
I would really appreciate your insights on this matter.
Rum
I have a excel data set with 7000 rows and about 10 columns.
Example: Columns are:
‘Login Id’; ‘Int Vs Ext’; ‘TA’; ‘Protocol’; ‘Site #’
Under all these heading of columns are multiple records:
Example: If there are 20 unique login ids each appears multiple times. So is
the case with Int Vs Ext, TA, Protocol, Site #
I am trying to find:
1. Average number of ‘protocols’ per ‘login id’
2. Average no of ‘sites #’ per ‘login id’
I have been trying to do this using a pivot table and I get a count of all
the protocols that correspond to a Login Id. This is a reflection of how many
times a protocol appears in the data set. But I multiple entries of the same
protocol to be counted as one. This way if a login Id had for example 100
protocol entries, I wish to get how many of those 100 protocol entries are
unique. Example: if XXX appears 20 times, YYY appears 30 times, ZZZ appears
50 times in protocol records I need it to be counted XXX, YYY, ZZZ each once
making it a unique count of 3.
I would really appreciate your insights on this matter.
Rum