Is there a way to total the timecard/timesheet by day not week?

[Julia Allen1]

Hello,

I need a way to pull a report that shows an employees daily total AND weekly total. Attached is a screenshot. How can this be done in SNOW?

I need all the hours for Monday at the bottom, then the line item total for the week (to the right)

Pivot tables don't seem to pull the data since it's coming from 2 different tables...

thanks in advance - 

[nataliya_b]

Do you have a lot of users to present? 

Maybe you could try to use trend type report and have something as below:

You also could add additional filter conditions for week_starts_on and getting data by user's departments (if there are many users) 

[yogesh41 · Accepted solution]

The Time Card daily records has been introduced in New York to capture daily hours for each weekly Time Card record. The `time_card_daily` table records can be aggregated to get total daily hours for a Time Sheet.

More details :

https://docs.servicenow.com/bundle/newyork-it-business-management/page/administer/task-table/concept/c_TimeCards.html

- Yogesh 

[Knight Rider]

Hello @Julia Allen1 ,
We are also looking for the same solution, could you please let me know that steps that you followed to achieve the solution.
Thanks in Advance!