At 03:45 PM 6/19/2009, jan johansen wrote:
Group,
I need to construct a view that compares actions by an employee
made last week to this week. So it's a single table view and
would look something like
EmpName 06/09/2009 06/16/2009 Result
Joe Shmoe 1 1
Snuffy Smith 1 1 2
I'm drawing a blank.
Jan,
Here is a simple and eloquent approach to achieve your goal.
Use the CrossTab control in R:BASE Report Designer.
Your report shall look like this:
http://www.razzak.com/sampleapplications/EmployeeStats.pdf
A quick R:BASE CrossTab report based on your sample data.
Enjoy the power and wealth of R:BASE!
Very Best R:egards,
Razzak.
P.S. Imagine the Possibilities!