I have sql query which retrives the daily actuals of resource for which I'm using a custom slice defined as attached.
But the issue is sometimes for most of the resources for a partucular week I dont get data in the sql even if the resource time sheet is posted.
In this case I have to manually update the prassignment.slice_status = 1 and run the time slice to get the user data in the result.
Mostly the users who are missing data for a partcular week is huge.
How to resolve this? Is updating the prassignment.slice_status is the only way?