Timesheet Details

The Timesheet Details dataset lists timesheets and their entries, for tracking hours by person, Work Order or Asset.

At a glance

Item Value
Picker heading Data Tables
One row is One timesheet entry, with its timesheet's header values
Presentations Table, Metric Tile, Bar, Column, Pie, Donut, Treemap, Gauge, Line, Area, Sparklines, Heatmap, Grouped Line, Column Chart Over Time, Line Chart Over Time, Area Chart Over Time
Default presentation Table
Default period Last 30 Days. Time charts start on Last Month.
Date basis Timesheet Date, the only option. Both boundary dates are included.
Default columns Header: Timesheet ID, Timesheet Date, Person Type, Person Name, Timesheet Status. Entries: Work Order / Category, Asset Number, Start Time, End Time, Entry Hours
Group Modes Detail tables. Charts can use Detail or Consolidated.
Drill-through Column Chart and Over Time charts

Measures

Measure Unit Aggregation Definition
Timesheet count Timesheets Count Number of timesheets.
Timesheet entry count Entries Count Number of entries. This replaces Timesheet count when grouped by Work Order or an Asset field.
Entries: Entry Hours Hours Sum Hours on each entry, added together.

Columns

Column labels start with Header for timesheet values, or Entries for entry values.

Section Columns Description
Header Timesheet ID, Timesheet Date, Timesheet Status The timesheet.
Header Person Type, Person Name, Employee ID, Contractor ID The person. Person Type is Employee or Contractor.
Header Timesheet Hours, Timesheet Work Order Hours, Timesheet Category Hours The timesheet's total hours and their split.
Header Submitted At, Submitted By, Submitted By ID Who submitted it, and when.
Header Approved At, Approved By, Approved By ID Who approved it, and when.
Header Rejected At, Rejected By, Rejected By ID, Rejection Reason Who rejected it, when and why.
Header Notes, Created At, Updated At Other timesheet details.
Entries Entry ID, Entry Type, Work Order / Category The entry. Entry Type is Work Order or Category.
Entries Start Time, End Time, Entry Hours The time on the entry.
Entries Work Order ID, Work Order Number, Work Order Title The entry's Work Order.
Entries Category ID, Category Name, Category Description, Category Paid, Category Active, Category Sort Order The entry's category.
Entries Asset ID, Asset Number, Asset Description The entry's Asset.
Entries Notes, Created At, Updated At Other entry details.
Asset Asset Department, Class, Group, Asset Type, Manufacturer The Asset's classification and department.
Asset Asset Status, Criticality, Planning Type, Hire Status, Project, Customer The Asset's details.

Filters

Filter Choice Behaviour
Employee, Contractor Multiple The person on the timesheet.
Timesheet Status Multiple Draft, Submitted, Approved or Rejected.
Site or Department Multiple The timesheet's department scope.
Entry Type One choice Work Order or Category.
Category Multiple The entry's category.
Work Order Number Multiple The entry's Work Order.
Asset Number Multiple The entry's Asset.
Asset Department Multiple The Asset's department.
Class, Group, Asset Type, Manufacturer Multiple The Asset's classification.
Asset Status, Criticality, Planning Type Multiple The Asset's details.
Hire Status Yes, No, All Whether the Asset is on hire.
Project, Customer Multiple The Asset's Project and Customer.

Group By

Group By Groups by
By Timesheet Each timesheet.
By Person Type Employee or Contractor.
By Person Name The person on the timesheet.
By Approved By The approver. Timesheets with none appear under Not Approved.
By Work Order The entry's Work Order. Entries with none appear under No Work Order.
By Asset The entry's Asset. Entries with none appear under No Asset.
By Asset Department The Asset's department.
By Class, By Group, By Asset Type, By Manufacturer The Asset's classification.
By Planning Type, By Asset Status, By Criticality The Asset's details.
By Hire Status On Hire or Off Hire.
By Project, By Customer The Asset's Project and Customer.

Chart notes

  • Group Mode set to Detail on an Entry Hours chart draws one bar per entry.
  • Series by and Compare are not available. Compare with is available on Over Time charts only.

Business rules

  • The count depends on the Group By. Grouping by Work Order or an Asset field counts entries. Other groupings count timesheets.
  • An entry's Asset can come from its Work Order. An entry with no Asset of its own uses its Work Order's Asset.
  • Entry hours are rounded per entry. Each entry is read to the minute and rounded to two decimals before adding up.
  • Tables are limited, charts are not. A Table lists up to 100 timesheets, while charts count every match.

For shared settings, see Widget and Chart Options. To choose another dataset, see the Data Dictionary.