Calendar report - Work_Week view doesn't have the correct days

[GuyHome]

Hi,

When I add a Calendar Report visualization the work week view goes from Sunday to Thursday instead of Monday to Friday and I'm struggling to find the place to define it.

I've added a calendar report to a par_dashboard like so:

1. Platform Analytics -> Library -> Dashboards
2. Find and open <my dashboard> then Edit
3. Add new element -> Data Visualization -> New Visualization
4. Change configuration of the new element/visualization
   1. Visualization type = Calendar Report

The selected values in configuration for the table, the start & end fields and the default view do not matter. The Work Week view stays Sun-Thu.

Where is the work week defined? What needs to change?

PS: Same behaviour in developer instance.

Thank you

[Sarthak Kashyap · Accepted solution]

Hi @GuyHome ,

I tried your problem in PDI and it works for me

Navigate to sys_properties.LIST table and create 2 property 

1 . glide.ui.date_format.first_day_of_week - type integer and value is 2 because 2 is Monday

2. glide.ui.date_format.last_day_of_week - type integer and value is 6 because 6 is Friday 

Please mark my answer correct and helpful if this works for you

Thanks and Regards,

Sarthak

[GuyHome]

Thank you so much!
Mind sharing where you found the documentation?
Or how you found out?

[Sarthak Kashyap]

Hi @GuyHome ,

I didn't find any official docs, but I got old community link here they mention for first day so I created for first day of week and created similar for last day of week, I tested and it works!

https://www.servicenow.com/community/servicenow-ai-platform-forum/week-start-and-end/m-p/1106157

Please mark my answer correct and helpful if this works for you

Thanks and Regards,

Sarthak

[GuyHome]

Thanks again. With that info I managed to find these 2.

• Available system properties - glide.ui.date_format.first_day_of_week 
  • Which states the default is 1 (Sunday)
  • 
• Modifying and adding calendar report system properties
  • Which states the default is 2 (Monday)😅
  •