# 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.

## Incorporating data from custom columns and adding it to formulas

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:

1. Add a custom column called **Number of FTE's** to the **Process** table in the **ROI Dataset** .

   ![Screenshot of the Number of FTEs column.](https://dev-assets.cms.uipath.com/assets/images/insights/insights-screenshot-of-the-number-of-ftes-column-157744-5e0290af-20cbaa4e.webp)

   :::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](https://docs.uipath.com/insights/automation-cloud/latest/user-guide/configuring-the-roi-dataset) section.
   :::
2. Navigate to the **UiPath Templates** tab.
3. Create a copy of the **Business ROI** template.
4. You can now modify the pre-existing calculations to also include the **Number of FTEs** custom column. To do that, take the following steps:
   a. Select the 3-dot menu in the top-right corner of the dashboard and select **Edit dashboard**.
   b. You can now decide which tile you want to edit. In this example, the **Time Saved** tile will be edited.
   c. Select the 3-dot menu in the top-right corner of the **Time Saved** tile and select **Edit**.

      ![Screenshot of the Business ROI template.](https://dev-assets.cms.uipath.com/assets/images/insights/insights-screenshot-of-the-business-roi-template-494354-bdb50a16-20777a93.webp)
5. 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.

   ![Screenshot of the Number of FTEs column.](https://dev-assets.cms.uipath.com/assets/images/insights/insights-screenshot-of-the-number-of-ftes-column-495559-1beae02e-bd09d288.webp)
6. 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.

   ![Screenshot of the Table Calculation button.](https://dev-assets.cms.uipath.com/assets/images/insights/insights-screenshot-of-the-table-calculation-button-494371-edd83ef0-c7898a8a.webp)

   ![Screenshot of the Create table calculation page.](https://dev-assets.cms.uipath.com/assets/images/insights/insights-screenshot-of-the-create-table-calculation-page-494376-d5f6ca3e-c8e34fb1.webp)
7. To edit the **Time Saved For All Processes (hrs)** table calculation, select the 3-dot menu next to the calculation, and then select **Edit** to see the entire formula.
8. 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.

   ![Screenshot of the Edit table calculation page.](https://dev-assets.cms.uipath.com/assets/images/insights/insights-screenshot-of-the-edit-table-calculation-page-494383-fae78e25-ada3f915.webp)
9. Select **Save** to update the table calculation.
10. 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.
    :::

## Combining Process and Queue information on the ROI Dashboard

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](https://docs.uipath.com/doc:draft_combining-process-and-queue-information-on-the-roi-dashboard#create-a-business-roi-copy)

Step 2: [Add custom views to Business ROI](https://docs.uipath.com/doc:draft_combining-process-and-queue-information-on-the-roi-dashboard#add-custom-views-to-business-roi)

Step 3: [Create custom metrics](https://docs.uipath.com/doc:draft_combining-process-and-queue-information-on-the-roi-dashboard#create-custom-metrics)

If you want to edit the ROI dataset, make sure that you have [Admin permissions](https://docs.uipath.com/insights/automation-cloud/latest/user-guide/granting-permissions#granting-permissions).

### Create a copy of the Business ROI Template

First, you need to copy your Business ROI to Dashboards.

1. Open UiPath Insights and go to the **UiPath Templates** tab.
2. On the Business ROI tile, select **Copy to My Dashboards** and enter a name
3. Select **Save** to create a copy. Your copy is placed in **My Dashboards**.

   ![Screenshot of the Copy to My Dashboards button.](https://dev-assets.cms.uipath.com/assets/images/insights/insights-screenshot-of-the-copy-to-my-dashboards-button-157768-d752111d-29bc97ee.webp)

### Add custom views to Business ROI

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:

* **Queue Name** in **Queues**.
* **Total Manual Time (mins)** in **Queues**.
* **Process Name** in **Jobs**.
* **Total Manual Time (mins)** in **Jobs**.

Continuing with this example, you need to edit the copied version of Business ROI.

1. Select the 3-dot menu in the top-right corner of the dashboard and select **Edit dashboard**.
2. You can now decide which tile you want to edit. In this example, the **Time Saved** tile will be edited.
3. Select the 3-dot menu in the top-right corner of the **Time Saved** tile and select **Explore from here**.

   ![Screenshot of the Explore from here button.](https://dev-assets.cms.uipath.com/assets/images/insights/insights-screenshot-of-the-explore-from-here-button-157868-1a54b47e-942dd2e8.webp)
4. Under the **Queues** view, select both **Queue Name** and **Total Manual Time (mins)**.

   ![Screenshot of the Explore page.](https://dev-assets.cms.uipath.com/assets/images/insights/insights-screenshot-of-the-explore-page-494391-c0ab1ab7-38f4b22e.webp)

A field (e.g.,**Queue Name**) adds a view within the Tile Explore.
5. Select **Run** so you can see the field values. As a best practice, filter out the queues that are null.

   ![Screenshot of the Explore page.](https://dev-assets.cms.uipath.com/assets/images/insights/insights-screenshot-of-the-explore-page-494396-23d989f3-a3e62357.webp)
6. Add another table calculation by selecting the **Add** button and select table calculation.

   ![Screenshot of the Add Table Calculation buttons.](https://dev-assets.cms.uipath.com/assets/images/insights/insights-screenshot-of-the-add-table-calculation-buttons-160678-f2a4438f-c132d13e.webp)
7. 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.

   ![Screenshot of the Edit table calculation page.](https://dev-assets.cms.uipath.com/assets/images/insights/insights-screenshot-of-the-edit-table-calculation-page-494403-ff9b1b1e-754a06cc.webp)
8. Create a new table calculation to sum **Time Saved for All Processes** and **Time Saved for all Queues**.

   ![Screenshot of the Edit table calculation page.](https://dev-assets.cms.uipath.com/assets/images/insights/insights-screenshot-of-the-edit-table-calculation-page-494408-b196e5d5-8b350ffc.webp)
9. Add the sum of the time saved per transaction field to create the new table calculation that encompasses queues and select **Save**.
   ```
   ${time_saved_for_all_queues_hrs} + ${time_saved_for_all_processes_hrs}
   ```
10. 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.

    ![Screenshot of the Explore page.](https://dev-assets.cms.uipath.com/assets/images/insights/insights-screenshot-of-the-explore-page-494415-f51f04c2-8cc161c1.webp)

:::note
* 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`.
:::