The Now Platform® Washington DC release is live. Watch now!
‎05-31-2019 04:37 PM
Hi,
1) I am trying to obtain a different view of what we see in Capacity planning of Resource Workbench. The requirement is to obtain stacked view of capacity of Resource groups and not the total capacity of filtered Resource Plans on the left panel. i.e. similar to "Stack by" and "Grouped bars" feature in reporting.
For instance, the attached image has 3 Resource Groups - Analysts, Database and Production Support. Jan's number of hours need to show three stacked columns with each group and not an aggregated hour and baseline. I was unable to find the source table of the heat map for this purpose to create a custom report.
2) Also, is there a source of "Resource Reporting" which is a OOB module for custom reporting.
Any information for custom reporting of Resource management is much appreciated.
Thanks.
‎05-31-2019 06:09 PM
Closest I've gotten to good custom resource management reports is with multi row pivot tables.
‎11-09-2021 05:20 AM
Hi Robert,
If you can please help me? I would be really grateful. I am not able to create proper reports. Somehow its not showing the correct data.
I have posted a question, if you can help me, I will mark your answer as correct.
https://community.servicenow.com/community?id=community_question&sys_id=2f9eec081bb73450cd3b33bc1d4bcbdc
Thanks,
Vaishnavi
‎06-01-2019 03:02 AM
Capacity Planning is implemented as Service Portal page, which uses Highcharts API directly. The URL of Capacity Planing is /ppsrp?id=ppsrp_rw_requested_list&sysparm_title=Capacity%20Planning, where ppsrp is the id of Resource Workbench portal and ppsrp_rw_requested_list is the id of the Service Portal page.
You can hold Ctrl and make right mouse click on the left or right part of Capacity Planning page to see the widget responsible for the part of the page. To edit the widget one should choose "Widget in Editor":
The widget "Resource Plans - Requested" (id="ppsrp-rp-requested-cards") use
$rootScope.$broadcast('ppsrp:plan_selection_changed', $scope.selectedPlans);
to send information about selected plans and the widget "Resource Availability - Requested" (id="ppsrp-rp-availability-requested") uses
$scope.$on('ppsrp:plan_selection_changed', onPlanSelectionChange);
to get the information. It has HighCharts as dependency and display the chart by usage HightChart API.
It's difficult to comment that whole parts of AngularJS code of the widgets, but I hope that investigation of the code and debugging of the client part of the code will help you to implement your requirements.
If you don't familiär with Service Portal development and want to implement your requirement in classical GUI that I'd recommend you to read "Building custom visualizations and interactive filters" session from Knowledge 2019 especially the part Custom Visuals Using the Table API, which demonstrates how to use Highcharts to create widgets, which can be used on Dashboard.