Weekdays and Weekend reporting for Change

[Amit Kishore]

Hi Team,

We have a requirement, we have to create  report on change table, where we would like to see reports on change implemented between "Monday to Friday"  and "Friday to Monday" so that client can ensure how many changes has been implemented during weekdays and weekends.

is there any OOB solution we have ? or we have to go for scripting ?

Note : We have Planed start and planed end date to capture the date and time.

Regards,

Amit

[Ct111]

Hello,

https://community.servicenow.com/community?id=community_question&sys_id=70ab03a1db9cdbc01dcaf3231f961936

Check the above link and response of Gaurav Chaudhary......

Mark my answer as Correct and Helpful if it helps

[Amit Kishore]

@samogden : Thanks for video, I am not getting the same option what it described in video. However we have field where are storing data and time together and we need the reporting in a way where we want report "Monday 8 AM to Friday 5 PM" and Friday 5PM to Monday 8AM".

kindly guide if we can achieve this with "relative" and "trend" option?

[Amit Kishore]

@creativethinker ; I tried this solution, but dint work. the options are not coming per the screenshot shared by Gaurav in my instances, I am using Orlando.

[Sam Ogden]

Hi Amit,

I've not watched the video for a while, just tried it on my PDI

I've created 6 test changes with different planned start date:

• Friday before 5PM
• Friday after 5PM
• Saturday
• Sunfay
• Monday before 8AM
• Monday after 8AM

I then have the report condition set as:

Which is giving me these results:

So the change before 5PM Friday and the change After 8AM Monday do not appear.  So it looks like you can get what your looking for with standard reporting - you may just need to fine tune the filter conditions further to meet what you need.

I did notice some inconsistency with the available options on the relative operator.  As you can see in the first and third of the OR conditions I could only select 'before' but on the middle condition it did show the option for 'on or before'.  Not sure what is causing this.  Might need to reach out the SN on that one.

I hope this helps - If so please mark helpful or correct

Thanks

Sam

[Amit Kishore]

Thanks all for assistance.

@Thomas Davis : This is really simple and nice approach however I have not an option to create/extend column/table in client instance, we have been asked to check OOB / scripting way to achieve it. 

Please guide an alternate way to achieve it.

@samogden : Thanks for video, I am not getting the same option what it described in video. However we have field where are storing data and time together and we need the reporting in a way where we want report "Monday 8 AM to Friday 5 PM" and Friday 5PM to Monday 8AM".

kindly guide if we can achieve this with "relative" and "trend" option?

@creativethinker ; I tried this solution, but dint work. the options are not coming per the screenshot shared by Gaurav in my instances, I am using Orlando.

Regard,

Amit