reporting
73 TopicsBookings Report Automation?
Here it is, August of 2024. We have multiple ai engines in existence. We have reusable space rockets. We have advanced robotics. We have VR headsets. What do we not have? An update to Microsoft Bookings reporting capabilities. I'm in a government account environment, so Power Automate isn't an option. MS Graph isn't an option. We're still operating off of a 2018 solution, an Excel connection to Online Exchange for reporting. We're unable to access custom field data without manually running the .tsv report out of our 18 Bookings pages. Even doing so, the custom field entries are lumped into a single column. I've opened a support ticket to Microsoft inquiring if there is a better way to access custom field data. Microsoft's answer was "no." Has anyone else out there figured out a workaround to automate access to custom field data in government account environments?378Views2likes0CommentsMaking 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