Monthly Report from time cards?

Robert_Cartwrig
Tera Expert

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

3 REPLIES 3

Allen Andreas
Administrator
Administrator

Hi,

Just because they're created/submitted weekly, doesn't mean you can't still report on it. Consider something like this:

find_real_file.png

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!

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

 

 

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!