Tips and Techniques: The formula bar

Klipfolio  is a powerful tool when it comes to manipulating data and providing key insights into your data. In this introductory article, you build a Klip using the formula bar. This Bar/Line Chart shows the top three fruit types as a percentage.

In the Klip Editor, select the X:Axis

Use the Insert data from a data source (Alt+A) button to select column A from the data source.


To check that the names of all the fruit types are returned, select column A:A in the formula editing toolbar, and then select the Evaluate current selectionbutton.


Next, select the Wrap current value in function button and select Data Manipulation, SLICE to remove the column header from column A.


An element of the SLICE function is start. Select start and then select the Insert literal string or number button and type 2 to start at line 3 of the data source, as (not set) is not a fruit type.

Select Series.

To start off this formula, select the Insert expression in parenthesis button.

Select the SLICE( A:A , 2 ) function from the X:Axis and use Ctrl+C and Ctrl+V to copy and paste it to the Series, and change the column A:A reference to column B:B.


Select the first ellipsis, and then select the mathematical operator Divided by /.


Select the the Insert function button, select SUM and for the data element select column B.


Select the second ellipsis, outside the round brackets, and the mathematical operator Multiplied by, and then select the Insert literal string or number button to type 100. Select the Y:Axis Properties panel, Format as to Percentage.

Tip: You can use the Undo change to formula (Alt+Z) button if you made a mistake.


To sort our Klip to display just the top 3 fruit types, apply the SORT and SLICE functions.

  • Select the SLICE function for the X:Axis formula, and then select Wrap current value in function, Data Manipulation, SORT.
  • Use Ctrl+C and Ctrl+V to copy the SLICE( A:A , 2 ) formula to the element returning values.
  • Change type to descending numeric.
  • Copy the Series formula: (SLICE( B:B, 2 , end ) / SUM( B:B ) over the first occurrence of SLICE( A:A , 2 ) at the values element.
  • Wrap the SLICE function around the whole X:Axis formula specifying a start of 0 and an end of 3.
    The finished formula looks like this:
    SLICE( SORT( ( SLICE( B:B , 2 ) / SUM( B:B ) ) , descending numeric , SLICE( A:A , 2 ) ) , 0, 3 )
  • Wrap the SORT function and then the SLICE function around the Series formula. As you are sorting by the Series formula, you do not need to copy the Series formula to returning values.

The finished formula looks like this:
SLICE( SORT( ( SLICE( B:B , 2 ) / SUM( B:B ) ) , descending numeric , 0, 3 ) * 100

Learn more:

Now that you know more about the formula bar, check out the following tutorials:

Important concepts

These articles provide an overview of important concepts for building Klips:

Feedback and Knowledge Base