I am seeing an issue when creating a time series report on the group_resource_aggregate_weekly table to where the values shown for particular users are one week off. This report is getting filtered by two interactive filters, one for user and the other for date range, if that matters. The weird thing is that if I drill down on one of the numbers to go to the list view of the filtered value, it will show the week after's data, the correct data.
When I click on the 3 value, it will show the following which corresponds to the 1 hour value the week after. Every week on this graph is off by one week.
My first thought is that the table has a field "Week Starts On" that gets set to a Monday, whereas the system value for week starts on AND time cards are all set to start on Sunday. You can see on the graph that it is showing 7-28 as the start of the week, but clicking into it the entry on the table has 7-29 as the start of the week. Is there a way to change the day of the week that this value gets set for the group_resource_aggregate_weekly table? I can't find anywhere in the system that shows how this gets set to change it.
Any help would be appreciated. Thanks!
