Report on changes for last 24 hours

Joshua Comeau
Kilo Sage

how to report on the following for the change table:
changes with a PLANNED END DATE in the last 24 hours

[2]changes with a Planned START DATE in the last 24 hours, current day and next 24 hours same as current dashboard

1 ACCEPTED SOLUTION

AndersBGS
Tera Patron
Tera Patron

Hi @Joshua Comeau 

 

To get the planned end date for the last 24 hours, you can utilize below filter when doing a report in the change_request table:

AndersBGS_0-1704978583228.png

 

To create the planned start date in the last 24 hours, you can utilize same filter as above, just with "planned start date" instead of "planned end date".

 

If you instead want to look 24 hours a head, the utilize below condition:

AndersBGS_1-1704978731922.png

 

 

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

2 REPLIES 2

AndersBGS
Tera Patron
Tera Patron

Hi @Joshua Comeau 

 

To get the planned end date for the last 24 hours, you can utilize below filter when doing a report in the change_request table:

AndersBGS_0-1704978583228.png

 

To create the planned start date in the last 24 hours, you can utilize same filter as above, just with "planned start date" instead of "planned end date".

 

If you instead want to look 24 hours a head, the utilize below condition:

AndersBGS_1-1704978731922.png

 

 

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Joshua Comeau 

 

Create 4 different reports

 

Plan start Date

LearnNGrowAtul_0-1704978619099.png

 

Plan end date

LearnNGrowAtul_1-1704978657711.png

 

 

LearnNGrowAtul_2-1704978780591.png

 

 

create these reports and add in Dashbaord. 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************