Date group query items are useful for reporting trends over
time. If you include a date group item and pivot your report on that item,
you can see how something is trending over time.
Work Entry Day—
Work Entry Week—
Work Entry Month—
Work Entry Quarter—
Work Entry Year—
Work Entry Created On—The
date the task work entry was created. This is not necessarily the date on which the work was done. Note: To see the date of the work in the work entry, use the Work Entry Day item in the Entry Date Groups.
Hourly Rate—The
hourly rate used for the work entry.
External Hourly Rate—The external
hourly rate used for the work entry.
Hours Worked—The
actual approved and unapproved hours entered in the work entry for the task.
Is Work Entry Approved—Whether
or not the work entry has been approved. Options are Noand
Yes.
Project Name—The
name of the project for which the work was done.
Project Type—The
project type of the project.
Is Non-Project Work—Whether
or not the task is non-project work. Options are No
(the default) and Yes.
Timesheet Task Comment—Any
comment added to the timesheet.
Work Entry Comment—Any
comment added to the work entry.
Note: IDs are included in the data model so you can join to other queries. Also, grouping on an ID can help separate different items with identical names.