Creating reports for hours worked from a timesheet in ServiceNow

Danielle10
Tera Contributor

‎04-13-2023 09:12 AM

Great day! Would someone be able to help me with this?

 

I am trying to create reports for hours worked from a timesheet in ServiceNow.


Which table should I be using? There is a Timecard table, Timesheet table, and Task table.

 

For the following reports, which table should I be using? 

  • Report by Project - # hours by person for each time period, including task name charged
  • Report for all RESOURCES People - # hours by day charged to all projects (don't need split out), PTO, S&O Administrative

 

0 Helpfuls
  • 1,461 Views
6 REPLIES 6

Mehta
Kilo Sage
Kilo Sage

‎04-14-2023 04:46 AM

Hi @Danielle10 , 

 

You should use Time Card table for reporting and can dot walk to Time sheet and select task. Time Card is usually against one Task/project task and associated with one timesheet. Whereas Time Sheet can be associated with n number of timecards. Therefore you will find time sheet reference store in time card record. 

Danielle10
Tera Contributor
In response to Mehta

‎04-14-2023 12:57 PM

Do you have a step-by-step example that I could follow?

0 Helpfuls

Mehta
Kilo Sage
Kilo Sage
In response to Danielle10

‎04-17-2023 03:09 AM

First step will be to use time card table for reporting purpose. 

Mehta_0-1681725660313.png

 

2nd Step is to set the filter, "task is 'PRJ0012344'", then you should apply grouping based on users.

 

0 Helpfuls

Danielle10
Tera Contributor
In response to Mehta

‎04-24-2023 08:26 AM - edited ‎04-24-2023 08:27 AM

What type of report would you advise to choose and use? Single score?

What should you put in the Configure tab?

Style tab? 

When you said that the 2nd Step is to set the filter, did you set the filter in the Conditions part?

0 Helpfuls