Klipfolio functions
Klipfolio offers a variety of Excel-like functions to perform calculations and manipulate data. The purpose of these functions is to help you display your data accurately. Each function has a specific syntax and parameters that must be assigned values in order to perform calculations. You can nest functions within each other and use additional formulas to satisfy the parameter. There are examples of nested formulas throughout this article.
Accessing the formula bar
Functions are used in the formula bar of the Modeller and the Klip Editor. The formula bar enables you to type in formulas or select from a list of functions. When you start typing a function name, a list of functions filtered by the letter you entered is displayed. Function Help with examples and parameters automatically displays for each function in a pop-up window.
It is important to note the differences when writing formulas in the Modeller and the Klip Editor:
- Calculations are performed in the Modeller to prepare and organize a data source and make the data source easier to use when building visualizations.
- Formulas in the Modeller reference tabular data by their sheet and column name, for example,
@A:Aor@Sheet 1, A:A. - Calculations are typically performed in the Klip Editor using modelled data sources. Using a data source that is already modelled enables you to focus on calculations that change the display of your data in order to build custom Klips to your liking.
- Formulas in the Klip Editor reference modelled data by their column name, for example,
@Productor@Shipment location.
Comments
Post a Comment