Highlights

 Component Type: Gauge Sub-components: Current Value, Target Value, Min Value, Max Value Data Source: Excel Spreadsheet Skills taught Use the formula editor to perform basic mathApply indicators to a component Audience Beginner

Step-by-Step

Building a Gauge Klip

To build the example Klip, you need to complete the following tasks:

• Start Klip building process
• Create a data source
• Assign data to Current Value component
• Assign data to Target Value component
• Adjust the Min and Max components
• Apply indicators to the Gauge component

Step 1: Start Klip building process

1. Click the Add a Klip button.
2. Click the Build a New Klip button
3. Select the Gauge component option.

Step 2: Create a data source

1. Select the Create a new data source option.
2. Select the Upload a File option.
3. Click the Choose File button.
4. Upload the following file: Exec Data
5. Click the Continue button.

Step 3: Assign data to the Current Value component

1. Delete the placeholder value `50`.
2. Select the value in cell `B2`.
3. Click the ellipses `...` to bring up the operator's toolbar.
4. Insert a division operator.
5. Select the Insert literal string option.
6. Type the following value: `1000000`

Important: Select the following options in the Properties Panel.

• Format as: Currency
• Decimal Places: .# (1)
• Suffix: M

Step 4: Assigning data to the Target Value component

1. Delete the placeholder value `80`.
2. Select the value in cell `D2`.
3. Click the ellipses `...` to bring up the operator's toolbar.
4. Insert a division operator.
5. Select the Insert literal string option.
6. Type the following value: `1000000`

Important: Select the following options in the Properties Panel.

• Format as: Currency
• Decimal Places: .# (1)
• Suffix: M

Step 5: Adjusting the Min and Max components

Min Component

• Deselect Show value on gauge option in the Properties panel.

Max Component

Change the value in the formula editor to `40`.
• Deselect Show value on gauge option in the Properties panel.

Step 6: Apply indicators to the Gauge component

1. In the Indicators panel, click the Add button.
2. Set the Predicate to state ` If: Current Value is greater than Target Value`
3. Set the Reaction to state ` then: Gauge change colour to green`
5. Set the Predicate to state ` If: Current Value is less than Target Value`
6. Set the Reaction to state ` then: Gauge change colour to red`
7. Save the Klip.

Important: Select the following options in the Properties Panel.

• Gauge style: Arc