I need to create a database with about 250 time entries, the entries are like this:
Date, User, Activity Description, Activity Type, Time
2/5/11, Jane, Read Email from Mark, Email, .1
2/6/11, Mark, Create email to Jane, Email, .2
2/7/11, Jane, Review spreadsheet, Review, .5
2/7/11, Mark, Review spreadsheet, Review, .5
Is it possible to then chart that data to show the following:
1 chart which shows how much time Jane spent versus how much time Mark spent on ALL activities so it would show 50% Jane and 50% Mark
1 chart which shows how much time was spent on email activity versus review activity so it would show .3 portion of time for email and 1.0 portion of time for review
and perhaps a bar chart showing activity per day for all users ?
Bookmarks