0 Replies Latest reply: Jan 30, 2012 7:32 AM by Balakrishnan TD RSS

How to create a custom report  to display a unique count

Newbie

Hi

 

Have to create custom report based on query parameter to get unique count of a parameter.

 

consider  the following data.

 

INPUT::

date  bookName

  dt1    book1

  dt1   book2

  dt1   book1

 

  dt2   book1 

  dt2  book3

  dt2   book4

 

(On each hit passing the custom parameters data and bookname)

 

EXPECTED OUTPUT:

 

date     unique book count

dt1       2

dt2       3

 

Created custom report with date as dimension and measure on bookname(count all hits)

 

ACTUAL OUTPUT:

 

date    unique book count

dt1      3

dt2      3

 

Count is not excluding the duplicate bookname.

 

Pleaes help.

 

Thanks & reagards,

Bala