Generate Derived Values

This document describes how to utilize Cost Intelligence Dashboards to generate derived values. Before generating derived values, it is essential to upload a dataset.

Prerequisite

The prerequisite to generating derived values within the Cost Intelligence Dashboards is that a dataset must be uploaded first.

Generate a Dataset

1. Click Actions and then Manage Files in the top right corner.

   

2. Select Create New Dataset and then upload the file.

Generating Derived Values

1. Click Actions and then Manage Files in the top right corner.

2. Select the dataset you want to derive values from.

   

3. Click Transformations on the right, above the Configurations column.

   

4. Drag the desired transformation into the Transformations panel. Transformations can be of the following categories:

   • Numeric
     • Addition
     • Division
     • Multiplication
     • Round
     • Subtraction
   • Text
     • Concatenate
     • Lowercase
     • Text Analysis
     • Text Replace
     • Trim
     • Uppercase
   • Date
     • Date Add
     • Date Difference
   • Logic
     • Array Filter
     • Array Flatten
     • Array Select Single Item
     • Formula
     • If/Else
     • Record Copy
   • External
     • Dataset Write

5. Select the parameters for the transformation. In the example below, a new column called Derived Savings is created by taking the difference between the pricing_public_on_demand_cost and reservation_effective_cost columns.

   

6. Validate the transformation in the Testing section. In the example below, the new column called Derived Savings appears in the output.

   

7. The new column opens with an ‘Added’ tag in the dataset. To apply the transformation and save the new derived value column, click Apply Changes.

   

   When all the steps above are completed, the derived value can be used in charts and dashboards. The new column will be available alongside the previous columns when configuring charts.