Reporting
72 TopicsMaking effort calculations work in Project for the Web (P4W)
Dear all, we are having a hard time with "efforts" in P4W since the system is directly calculating the hours based on the number of assigned resources and the duration of the task. This does not reflect the reality in most organizations so a manual entry of the correct effort is needed. Since this feature seems to be missing for now I'm wondering how all of you are working around this lack of flexibility right now. I came up with the following scenarios but none seems to be a great fit: Scenario 1 - Split tasks Create one tasks with the correct effort but ignore the due date and create a milestone to indicate when the task needs to be completed. Advantage: Effort would reflect correct # of hours Drawback: First task would instantly appear as running late or late Scenario 2 - Ignore efforts in P4W Create single task and only pay attention to the duration. Outsource any effort and resource management to another system. Advantage: Gantt chart view would look correct. Drawback: Requires a separate system for effort and resource management. Any PowerBI reports are still reporting nonsense. Scenario 3 - Extend P4W to outsource efforts to a custom object Use custom CDS entity to store the actual efforts. Advantage: Effort calculation would be correct and appear in the same system. Drawback: The efforts cannot be entered in the project.microsoft.com user interface Please let me know if I missed a scenario or share you best practice! Thanks, https://www.linkedin.com/in/muellersmartin/3KViews2likes7CommentsHelp with Connect to a SharePoint List (Power Query)
Hi all, When trying to connecting to an online SharePoint list in excel it gives me the option to use Anonymous, Windows or Organizational account. I mistakenly chose Anonymous and got this error: Unable to Connect - We encountered an error while trying to connect. Details: "Access to the resource is forbidden." When I try to go back to connect using Organisational account, it skips that option and goes straight to the above error.Solved3.7KViews1like1CommentDetailed PSTN user reporting
With remote working being the norm at the present , we have adopted Microsoft Teams to handle our incoming / external customer calls, is there a recognise way now to report on the individual stats of a user or a group of users in the same team? for Example , Total incoming calls for user/team Total external calls for user/team Calls taken in the Day/Week/Month/Year for user/Team Average duration of a call in the Day/Week/Month/Year for user / Team Total duration of a calls in the Day/Week/Month/Year for user / Team Can anyone else relate to this question? thanks Chris4.4KViews1like1Comment