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).