Analytics Time sheet

  • Release version: Zurich
  • Updated July 31, 2025
  • 4 minutes to read
    • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Analytics Time sheet

    The Analytics Time sheet provides ServiceNow customers with a comprehensive dashboard for monitoring and managing time sheet activities. It leverages Performance Analytics to deliver trend insights and regular reports on time sheet submissions, approvals, rejections, and resource allocation. This tool is essential for time card approvers, project and portfolio managers, and business stakeholders who require visibility into time management and resource utilization.

    Show full answer Show less

    Starting with the Zurich release, the Time Sheet Dashboard is renamed to Analytics Time sheet for new customers.

    End Users and Roles

    • Portfolio Manager (itportfoliomanager): Requires oversight of time sheet activities and necessary actions.
    • Program Manager (itprogrammanager): Needs visibility into resource time sheet activities and related actions.
    • Project Manager (itprojectmanager): Has access to the dashboards for monitoring.
    • Time Card Approver (timecardapprover): Monitors time sheet activities and approvals.
    • Business Stakeholder for PPM (snppmread): Views time sheet activities and related metrics.

    Key Indicators

    The dashboard’s Overview, Delinquent Activity, and Analysis tabs feature widgets tracking vital metrics sourced from the timesheet and users tables. These indicators help customers monitor timeliness, volume, and status of time sheets, including:

    • Counts of active time sheet users and total time sheets for various periods (week, month, quarter, year)
    • Percentage and counts of late time sheets by period
    • Counts of time sheets in states such as Approved, Pending, Recalled, Rejected, and Submitted for the current week
    • Counts of users who have not submitted time sheets for the current week

    Data Breakdowns and Visualizations

    Data can be broken down by user, manager, department, cost center, portfolio, program, and project, providing flexible views tailored to organizational needs.

    Visualizations include various chart types and lists to represent time sheet data effectively:

    • Single score widgets: Show counts of rejected, late, and pending approval time cards over the last 30 days.
    • Bar charts: Display time cards by state, total hours by category, and count of over-allocated resources (time sheets over 40 hours).
    • Heat maps: Present breakdowns of hours spent by resource across project time categories.
    • Lists: Provide detailed views of time cards submitted by individual resources.
    • Time series line and step charts: Illustrate weekly trends of total hours and monthly comparisons of allocated versus actual hours.
    • Expense type grouping: Shows time cards categorized by Capital Expense (Capex) and Operating Expense (Opex).

    Note: The “Time Sheets Over 40 Hours” report does not refresh when filtering by portfolio, program, or project.

    Practical Benefits

    ServiceNow customers can use Analytics Time sheet to improve time management visibility, ensure timely submissions and approvals, identify resource allocation issues, and support data-driven decision-making in project and portfolio management. The role-based access ensures relevant stakeholders see appropriate information to take timely and informed actions.

    The Analytics Time sheet provides comprehensive time sheet activities and reports to the time card approvers and time card users. The dashboard uses Performance Analytics to provide a trend of historical data and regular reports. It gives an overview of the time sheet activities of resources, time sheet approval and rejection rate, over-allocated and under-allocated resource counts.

    Important:
    Starting with Zurich release, Time Sheet Dashboard is renamed to Analytics Time sheet for new customers.
    Figure 1. Overview tab
    Screenshot for Overview tab of Analytics Time sheet
    Figure 2. Delinquent Activity tab
    Screenshot for Delinquent Activity tab of Analytics Time sheet
    Figure 3. Analysis tab
    Screenshot for Analysis tab of Analytics Time sheet

    End user and roles

    End user and goal Required role
    Portfolio manager: Needs visibility into time sheet activities of resources and actions that should be taken. it_portfolio_manager
    Program manager: Needs visibility into time sheet activities of resources and actions that should be taken. it_program_manager
    Project manager: Has access to the dashboards. it_project_manager
    Time card approver: Needs visibility into time sheet activities of resources and actions that should be taken. timecard_approver
    Business stakeholder for PPM: Needs visibility into time sheet activities of resources and actions that should be taken. sn_ppm_read

    Indicators

    The Overview, Delinquent Activity, and Analysis tabs in the dashboard contain widgets with the following indicators. The data for time sheets and time cards is collected from the [time_sheet] table and the data for users is collected from the [users] table.

    PPM – Active Time Sheet Users
    Count of active users with the timecard_user role.
    PPM – % Late This Year
    Percentage of time sheets late this year.
    PPM – % Late This Week
    Percentage of time sheets late this week.
    PPM – % Late This Quarter
    Percentage of time sheets late this quarter.
    PPM – % Late This Month
    Percentage of time sheets late this month.
    PPM – Late Time Sheets This Month
    Count of late time sheets this month. The indicator includes time sheets of the current month until the past week that are not in the Approved or Processed state.
    PPM – Late Time Sheets This Quarter
    Count of late time sheets this quarter. The indicator includes time sheets of the current quarter until the past week that are not in the Approved or Processed state.
    PPM – Late Time Sheets This Week
    Count of late time sheets this week. The indicator includes time sheet of the past week that are not in the Approved or Processed state.
    PPM – Late Time Sheets This Year
    Count of late time sheets this year. The indicator includes time sheets of the current year until the past week that are not in the Approved or Processed state.
    PPM – Total Time Sheets Last Week
    Total number of time sheets for the past week.
    PPM – Total Time Sheets This Month
    Total number of time sheets for the weeks in the current month.
    PPM – Total Time Sheets This Quarter
    Total number of time sheets for the weeks in the current quarter.
    PPM – Total Time Sheets This Year
    Total number of time sheets for the weeks in the current year.
    PPM – Time Sheets Approved This Week
    Count of time sheets approved this week. The indicator includes time sheets in the Approved or Processed state.
    PPM – Time Sheets Missing This Week
    Count of users with the timecard_user role who did not submit time sheet for the current week.
    PPM – Time Sheets Pending This Week
    Count of time sheets pending this week. The indicator includes time sheets for the current week in the Pending state.
    PPM – Time Sheets Recalled This Week
    Count of time sheets recalled this week. The indicator includes time sheets for the current week in the Recalled state.
    PPM – Time Sheets Rejected This Week
    Count of time sheets rejected this week. The indicator includes time sheets for the current week in the Rejected state.
    PPM – Time Sheets Submitted This Week
    Count of time sheets submitted this week. The indicator includes time sheets for the current week in the Submitted state.

    Breakdowns

    • User
    • Manager
    • Department
    • Cost Center
    • Portfolio
    • Program
    • Project

    Data visualizations

    Title Type Description
    Rejected Single score Single-score chart Number of time cards that are in the Rejected state for the last 30 days.
    Late Single score Single-score chart Number of time cards that were submitted late in the last 30 days.
    Pending Approvals Single score Single-score chart Number of time cards that have approval pending in the last 30 days.
    By State Bar chart Bar chart Number of time cards in the last 30 days, grouped by their state.
    By Category Heat map Heat map chart Breakdown of time spent (hours) by a resource across different project time categories in the last 30 days.
    By Resource List List chart The list of time cards submitted by a resource in 30 days.
    Total Hours Bar chart Bar chart Total time (hours) spent on by different categories.
    Total Hours by Week Starts On Time series line time series line chart Weekly trend of the total time (hours) spent on different categories over a period of time.
    Time Sheets Over 40 Hours Bar chart Bar chart Count of time sheets over 40 hours indicating over-allocated resources.

    This report does not refresh when you select portfolio, program, or project.
    Allocated vs Actual Hours Time series step Time series step chart Monthly trend comparing the total allocated hours versus actual hours for all time card users.
    Time Cards By Expense Type Bar chart Bar chart Time cards grouped by expense types: Capital Expense (Capex) and Operating Expense (Opex).