Daily Activity Summary

Default Access Rights

This report can be run by the following roles: Manager

Overview

Provides a summary, per day, of the paid, unpaid, and total time spent in each activity per organization.

Daily Activity Summary

This report is similar to the Activity Roll-up report, but for each activity, this report gives a summary of the time spent in the activity for each day within the selected time period. This report can also be run for a week or a month and analyzed to identify any trends in how much time is spent in particular activities day after day. If the typical selections for reporting are entire organizations and full days, this report can be used as an alternative to the Activity Roll-up report, without the need to create filters for each organization.

Inputs

  • Employee Filter: Indicates the set of employees to report on. (This report is in organization time zone)

  • Time Frame (reports that are by day and in organization time zone):

    • Last <X> days: This field specifies which days to report on. This mode should return the last X completed workdays for an organization, however, as implemented, it sets the From-date to the current day in the time zone of the SQL Server computer minus X days and the To-date to the current day in the time zone of the SQL Server computer. Depending on the difference between the SQL Server computer’s time zone and the organization's time zone and day/week boundary, this may not be the last X completed workdays.

    • From/To date (reports that are in organization time zone): These reports are generally by day or by week. Here, by day/week means the organization's workday or workweek, considering day and week boundaries. So, let’s say you want to report on the workdays 1/10/04 - 1/15/04. The workday named, 1/10/04, is actually 1/10/04 8:00am - 1/11/04 8:00 a.m. (in the organization's time zone). It will map differently in GMT. Now, let’s also assume that you are reporting on multiple organizations, each with different time zones and day/week boundaries. You are requesting data on 1/10/04 - 1/15/04, but this could map to different absolute times for each organization. For example:

      Org A: 1/10/04 3:00 a.m. - 1/11/04 3:00 a.m., 1/11/04 3:00 a.m. - 1/12/04 3:00 a.m....

      Org B: 1/10/04 8:00 a.m. - 1/11/04 8:00 a.m., 1/11/04 8:00 a.m. - 1/12/04 8:00 a.m....

Outputs

When the report has been run using the Last <x> days parameter, the report header’s From field shows the value of that parameter, such as From: Last 30 days. This is in contrast to previous releases, where the From field showed a date.

  • Activity: The activity being aggregated.

  • Organization Name: The organization being aggregated.

  • Paid Time (Hours): Returns the paid hours for intersecting portion of time entries.

    In reports that show hours, minutes are shown as decimal portions of an hour. For example, 2 hours 30 minutes would be shown as 2.5 hours.

  • Unpaid Time (Hours): See paid time.

  • Total Time (Hours): See paid time.