Create a report to show changes on weekends only.

Ashcorp
Giga Contributor

‎07-18-2024 02:21 PM

I've been tasked with creating a dashboard the house changes that occur on the weekends. On Monday when i review the dashboard i need to see changes that had a planned start date of that Saturday and Sunday. Anyone can help with this ?

0 Helpfuls
  • 568 Views
2 REPLIES 2

Dr Atul G- LNG
Tera Patron
Tera Patron

‎07-18-2024 09:59 PM

Hi @Ashcorp 

 

Try the trend operator:

 

AGLearnNGrow_0-1721365174151.png

 

 

*************************************************************************************************************
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]

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

AndersBGS
Tera Patron
Tera Patron

‎07-18-2024 11:28 PM

Hi @Ashcorp ,

 

utilize the condition “planned end date trend is on day = Saturday or Sunday. This would give you what your looking for.

 

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/

0 Helpfuls