Monthly Report from time cards?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-20-2018 03:36 PM
Hi folks,
I have an enhancement request to build a report of the hours submitted by month, but time cards are reported weekly regardless on month begin and endings.
Resource Plans have a built in monthly report, but it is based on weekly reporting. What is the best way to go about building a report that does monthly reporting on time cards?
Any help would be appreciated.
Thank you,
Robert

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-20-2018 04:31 PM
Hi,
Just because they're created/submitted weekly, doesn't mean you can't still report on it. Consider something like this:
Look in to maybe tweaking a few things, but this will give you a trend for the month by total (which would be hours on the time card).
Please mark reply as Helpful/Correct, if applicable. Thanks!
Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-21-2018 08:33 AM
Hi Allen,
Thanks for the reply, but I believe this will do exactly what I'm saying I don't want to do. I don't want a report of time cards where part of the week happened to be in the month I'm reporting on...I want to report hours for days that fall only in the month I'm reporting on.
Say I want to report on hours by bill rate for the month of October. If a week begins on September 31st, I only want the hours from the days that fall in October. So I don't want that day in September...I only want the days beginning on October 1st.
Am I missing something?
Regards,
Robert

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-21-2018 07:03 PM
Without setting up your own business process for this if this is something you'll want to capture, you won't be able to pull any report for specifically that month. 1-30 or 1-31, etc. Some will bleed in to the next month, etc. See this link for people talking about the very same thing you want to do: https://community.servicenow.com/community?id=community_question&sys_id=890a0369db5cdbc01dcaf3231f96... the thread started three years ago and people as of 3 months ago are still talking about it. You all would need to develop a process where you just understand that overall, for the year, the way I showed would get you what you want, it would average it out OR you have your users submit maybe two time cards if that week breaks in to the next month (as mentioned in the post).
Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!