Skip to Content
0
Jul 22, 2009 at 04:26 PM

Help on count

19 Views

I am trying to solve this problem. I am trying to get count on Address table.

Here is what I am trying to do:

Employee	Date	       	    Address
--------	----                  -------	
John Doe	1/1/2009	             123 Main Street
John Doe	1/1/2009	             456 Broadway St
John Doe	1/1/2009	             123 Main Street  <- 2 address visit for 1/1/2009
John Doe	1/3/2009	             348 Commerce St  <- 1 address visit for 1/3/2009
John Doe	1/5/2009	             123 Main Street
John Doe	1/5/2009	             456 Broadway St  <- 2 address visit for 1/5/2009
John Doe	1/7/2009	             873 Water Blvd.  <- 1 address visit for 1/7/2009

I am trying to get the address visit per day for employee (John Doe)

On Webi, I use Employee and Address with the count of Address. It give

me the total of 4 where it is suppose to be 6.

If I put down Date, it will show 6. But I don't want the Date to be shown.

Any idea on how to solve that problem? Is something I have to do on Universe

or on Web Intellience (Webi).