Example - Revenue YTD Klip

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 math
Apply 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
  4. Add a second Condition.
  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

This is what your Klip should look like:


Learn more

More tutorials

Klip Tutorials

  1. Introduction
  2. Introduction to the Build-a-Klip Tutorial
  3. Build-a-Klip Tutorial: Phase One
  4. Build-a-Klip Tutorial: Phase Two
  5. Build-a-Klip Tutorial: Phase Three
  6. Build-a-Klip Tutorial: Phase Four
  7. Build-a-Klip Tutorial: Phase Five
  8. Example - Revenue YTD Klip
  9. Example - Financial Performance YTD Klip
  10. Example - World News Klip
  11. Example - Bookings by Country Klip
  12. Example - Bookings QTD Klip
  13. Example - Stock Quotes Klip
  14. Example - Marketing Traffic Sources Klip
  15. Example - 75/20 Service Level - Today Klip
  16. Training Klip - Array, Slice, Reverse, If, and Trim Functions
  17. Training Klip - Sum, Average, and Count Functions
  18. Training Klip - Group and Groupby Functions
  19. Training Klip - Date, Datevalue, and Today Functions
  20. Training Klip - Replace function and image URLs
  21. Training Klip - Concat and Join Functions
  22. Common Bar/Line Chart scenarios: Example of using the LOOKUP function with a condition to align data
  23. Common Bar/Line Chart scenarios: Example of using the LOOKUP function to align data
  24. Common User Input Control scenarios: Displaying total boxes of fruit sold in the last three months
  25. Common User Input Control scenarios: Counting all tickets by quarter, by month, by weekday
  26. Common Table scenarios: Selecting start and end dates to display number of boxes sold by country
  27. Common Table scenarios: Sorting data to display the video with the highest number of views
  28. Common Pie Chart scenarios: Displaying total number of surveys as a percentage by country
  29. Common Pie Chart scenarios: Displaying numbers and percentages in a pie chart legend

Feedback and Knowledge Base