Using the FO&M Timecard Dashboard

This guide provides essential steps for accessing and navigating the Weekly Timecard Dashboard, making it easier for supervisors to manage employee timecards. It highlights key features, such as visual indicators for hours worked and options for filtering and exporting data.

Jennifer Fullerton
21 steps
51 seconds

Dartmouth

Microsoft Power BI

Navigate to [Facilities.Dartmouth.edu](https://facilities.dartmouth.edu/home/BP/WebClient?2)

Click "FO&M Supervisors"

Click "Timecard dashboard"

After selecting the "Timecard Dashboard" you will be redirected to a page titled "Microsoft Power BI". This is the view on Google Chrome

Firefox view

The "Timecard Dashboard" opens

Scrolling all the way to the right shows you the total hours worked by an employee for that given fiscal year. Looking at the columns that show weeks will show you the total hours worked by an employee for that week.

Employees with more than 40 hours in a given week will be highlighted in purple; employees with less than 40 hours in a given week will be highlighted in red.

To filter inside the Timecard Dashboard, utilize the functions up top and edit the ones necessary to filter and find the information you need

Filter Field Definitions: Fiscal Year - The year in which you are able to see employees weekly hours worked, and their total hours worked for that fiscal year TradeCode - This allows you to filter and see employees associated/assigned to different trades under the FO&M umbrella Pay Type - Shows you the different pay types (Regular & Leave, Premium) of which employees have billed hours under NetID - Allows you to search employees directly by using their NetID or their full name Employee Type - Give you the ability to filter by certain types of employee, such as affiliate, faculty, or staff Billable - Shows you the work order billable status, allowing you to see if this goes to the General Ledger or not. Timecard Status - Status of the timecard entry, telling you if it has been accepted, in preparation, or submitted for approval Billing Line Status - Have the billing lines associated to these labor hours been billed to the GL or not. (Billed, pending, or written off)

Timesheet date columns are summarized by Week, Month, and Quarter. When you first open the report, you will see the default view of Week (columns). Hovering your mouse over the spreadsheet will activate a Drill-On menu to appear in the top right corner

Click on the Drill-On menu dropdown to select "Columns"

Click on the up arrow to go to the next hierarchy (Months)

Click it again if you would like to go to the top level (Quarters). Once at the final Drill-Up, the arrow will turn grey

To return to the lower levels, click on the double arrow icon

If you would like to see all levels and totals per group, you can select the expand icon in the top right

Another option to expand is by right-clicking on the header and select "Drill-Down" or "Expand to next level". Please note, "Drill-Down" will expand the column selected, where "Expand to next level" will expand all

To see more information on an employees timecard, click the collapse button next to their name

Select to collapse "Regular and Leave", or "Premium" to see the specific hours and pay rates associated with each employee

To export data or sort the data table through a different method, click the three dots at the top right of the data field

To see the last date at which an employee submitted their timecard, click "Last Timecard Submission by Employee" at the bottom left of the screen.

This is the screen you will be brought to, giving you the ability to filter by TradeCode and scroll to find the information you are looking for

The "Last Timecard Submission by Employee" will be valuable to supervisors who want to make sure their employees are staying up to date with their timecard, and allows you to see when employees had last submitted their timecard.

To access the "Data Export" level, select it at the bottom right of your screen

This page will display Timecard Insert Date, and the Timecard Approval Status for technicians. That data can be found here on the page

Using the FO&M Timecard Dashboard

Jennifer Fullerton
21 steps
51 seconds