- Release Notes
- Getting Started
- Installation and Upgrade
- Access and Permissions
- Interacting with Insights
- Logs
ROI Customizations and Calculations
You can add a custom column to a copied Business ROI template or to a Business ROI dashboard that you created from scratch. The following example covers adding a custom column to a copied Business ROI template.
To incorporate data from a custom column, take the following steps:
-
Add a custom column called Number of FTEs to the Process table in the ROI Dataset .
Note: For more details on how to add a custom column to the ROI Dataset, refer to the Adding Custom Columns to the ROI Dataset section. - Navigate to the UiPath Templates tab.
- Create a copy of the Business ROI template.
- You can now modify the pre-existing
calculations to also include the Number of FTEs custom column. To do that,
take the following steps:
- Click the 3-dot menu in the top-right corner of the dashboard and select Edit dashboard.
- You can now decide which tile you want to edit. In this example, the Time Saved tile will be edited.
-
Click the 3-dot menu in the top-right corner of the Time Saved tile and select Edit.
-
To add the custom column to your tile, click the Process Manual Values explore if you added a custom column to the Process table. You can now see the custom column available for use.
Note: You must select the Queue Manual Values explore if you added the data into the Queues table in order to add the custom column to your tile. - To add this custom column to the pre-existing formula for Time Saved, open the Time Saved Per Process (hrs) table calculation. Click the In-Use tab in the field picker to see the custom fields used in the Time Saved tile.
-
To edit the Time Saved Per Process (hrs) table calculation, click the 3-dot menu next to the calculation, and then select Edit to see the entire formula.
-
You can now add in your custom column to the formula directly. In this example, you can simply multiply the calculation by the number of FTEs so that you can account for multiple employees working on a given process.
- Click Save to update the table calculation.
-
Lastly, click Save one more time to save the updated tile.
To combine Process and Queue information on a Business ROI dashboard, You can either use a copied Business ROI Template or use a ROI dashboard that you created from scratch on which you can include data from Queues Tables into your current calculations. The following example walks you through adding Queue data to a Time Saved tile within a copied version of the Business ROI dashboard.
- Step 1: Create a copy of the Business ROI template
- Step 2: Add custom views to Business ROI
- Step 3: Create custom metrics
If you want to edit the ROI dataset, make sure that you have Admin permissions.
First, you need to copy your Business ROI to Dashboards.
- Open UiPath Insights and go to the UiPath Templates tab.
- On the Business ROI tile, click Copy to My Dashboards and enter a name
-
Click Save to create a copy. Your copy is placed in My Dashboards.
Now you can add the fields used to calculate the time saved for each transaction to the total time saved per process. For this example, you will be using the following fields:
- Transaction Duration in Seconds in Queues.
- Queue Item Count in Queues.
- Queue Name in Queue Manual Values.
- Total Manual Time (mins) in Queue Manual Values.
- Total Run Time in Seconds in Jobs.
- Process Name in Process Manual Values.
- Total Manual Time (mins) in Process Manual Values.
Continuing with this example, you need to edit the copied version of Business ROI.
- Click the 3-dot menu in the top-right corner of the dashboard and select Edit dashboard.
- You can now decide which tile you want to edit. In this example, the Time Saved tile will be edited.
-
Click the 3-dot menu in the top-right corner of the Time Saved tile and select Edit.
-
Search for Queue Manual Values and then click both Queue Name and the Total Manual Time (mins) fields to add them to the calculation.
:fa-info-circe: A field (e.g.,Queue Name) adds a view within the Tile Explore.
- Next, click the Transaction Duration in Seconds and Queue Item Count fields from the Queues Explore.
-
Click Run so you can see the field values.
-
Add another table calculation by clicking on the Add button and select table calculation.
-
Then, let's add our transaction data to the formula directly. We can copy the format used for calculating the time saved for a process, and replace the jobs fields with the queue fields and add the two together to obtain our combined metric . Lastly, add a name the new table calculation.
You can copy the format used for calculating the time saved for a process, and replace the jobs fields with the queue fields and add the two together to obtain our combined metric.
${queues.count}*(${queuemanualvalues.queuename.total_time}/60 - ${queues.transaction_duration_in_seconds}/3600)${queues.count}*(${queuemanualvalues.queuename.total_time}/60 - ${queues.transaction_duration_in_seconds}/3600) - Find Total Hours Saved for All Processes in the Custom Fields section, click the vertical ellipsis and select Edit to open the table calculation table so that we can add in the time saved for transactions to our time saved for processes.
-
Add the sum of the time saved per transaction field to create the new table calculation that encompasses queues and click Save.
sum(${time_saved_per_process_hrs}) + sum(${time_saved_per_transaction})sum(${time_saved_per_process_hrs}) + sum(${time_saved_per_transaction}) -
To display only the Total Hours Saved for All Processes column, you need to hide every other column from the data views by clicking the gear icon and selecting Hide from Visualization. The Time Saved value is now visible in the visualization.
The Time Saved value is now visible in the visualization.
is not null.
