Build-a-Klip Tutorial: Phase Five

As a final step, let's use a SUBSTITUTE function to replace "not set" to unknown in our chart.

Phase Five: Advanced Functions

You can follow along with our video as well as our step-by-step guide.



In the Chart component, (not set) is not a terribly useful label for its corresponding data set. Let’s use a function to change (not set) to Unknown.

  • Select X Axis in the Component Tree.
  • On its Data Panel, click the Wrap with Function button.
Navigate through the Text submenu to select SUBSTITUTE.
Note that the vector, A2:A7, is still represented in the formula. Click on the old text link in the formula and select (not set) in your data.
Click on new text in the formula. Using the Insert literal String or Number button, enter the text “Unknown” and click Apply.
Your Chart will update and any references to "(not set)” will be replaced by Unknown.
Save your Klip.
Let’s save your Klip. Click the Save button at the top right corner of the Klip Editor.
Add a description if you wish. When you’re finished, click the Finished button.

Congratulations! You have created your first Klip with multiple components!

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