- Release Notes
- Getting Started
- Access and Permissions
- Interacting with Insights
- Overview
- ROI customizations and calculations
- Custom Variables
- Alerts and Schedules
- Forecasting
- Historical data export
- Logs
- Performance and Scalability
- Real-time data export
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 FTE's
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, select
the Business ROI explore if you added a custom column to
the Process table. You can now see the custom column available for use.
- To add this custom column in the Time Saved
Calculation, create a new table calculation to multiply the amount of
employees by the time per process saved.
- To edit the Time Saved For All Processes (hrs) table calculation, click the 3-dot menu next to the calculation, and then select Edit to see the entire formula.
- Update Time Saved For All Processes (hrs)
to instead use the new table calculation incorporating Number of FTE's into
the equation. In this example, we are using our previously defined table
calculation, Time Saved Per Process for Multiple Employees, and summing that
to get our estimated time saved across all processes.
- Select Save to update the table calculation.
- Lastly, select Save one more time to save
the updated tile.
Note: The value you see in the visualization in edit mode may be different from the one the tile displays on the dashboard. This is because any filters on the dashboard do not affect a tile while in edit mode.
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 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 Queues.
- Total Manual Time (mins) in Queues.
- Total Run Time in Seconds in Jobs.
- Process Name in Jobs.
- Total Manual Time (mins) in Jobs.
Continuing with this example, you need to edit the copied version of Business ROI.
- Select 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.
- Select the 3-dot menu in the top-right corner of
the Time Saved tile and select Explore from here.
- Under the Queues view, select both
Queue Name and Total Manual Time (mins).
A field (e.g.,Queue Name) adds a view within the Tile Explore.
- Select Run so you can see the field
values. As a best practice, filter out the queues that are null.
- Add another table calculation by clicking on the
Add button and select table calculation.
- Add the transaction data to the formula directly.
Copy the format used for calculating the time saved for all processes. Add a name
for the new table calculation.
- Create a new table calculation to sum Time
Saved for All Processes and Time Saved for all Queues.
- 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
Queues and Processes column, you need to hide every other column from the
data views by selecting the gear icon and choosing Hide from Visualization.
The total hours saved for queues and processes is now displayed in the widget.
The Time Saved value is now visible in the visualization.
- If a particular process uses queues, enter a zero in the process ROI dataset. Instead, the ROI values should be input in the queues. For instance, if Process A uses Queue B, avoid entering ROI values for both Process A and Queue B as this could lead to double counting of the benefits. Therefore, it's recommended to input the ROI values only in the queue.
- The filters for the job and queue status impacts the numbers displayed in the dashboard. If you want to filter only the successful jobs or queue items, you must create custom measures..
- If a Queue Name does not have an associated process name, it will break
the calculation. To fix this issue, make sure that you apply the Process
Name dimension as a filter and set it to
is not null
.