Data functions are the Spotfire way of letting statisticians or mathematicians enhance Spotfire by creating scripts that can perform pretty much any type of calculation and returning the results to a Spotfire analysis. If the data function is saved in the library, anyone with an installed Spotfire client and an authoring license can use the predefined data function when creating a new analysis. Consumer users can benefit from the results of the calculations when interacting with the finished analysis.
Due to their flexibility, data functions can be used for many different things, for example:
Opening data.
Transforming data.
Adding features to a visualization (for example, curves) by addition of a new data table, based on the first one.
In most cases, the use of a predefined data function is a matter of mapping inputs to outputs, that is, the script requires someone to say what to base the calculations on, and where to place the result from the calculation, in the context of your current analysis.
Inputs can, for example, be a value, a column or a data table in your current analysis, but it is also possible to let the script import data from somewhere else, and have the data function as the source for the first data table in the analysis. Input values can, for example, be a document property which is provided by the end user using a property control in a text area.
The output is any combination of numeric values (e.g., model coefficients, forecasts, etc.), text (e.g., summary diagnostics) or even R graphical objects. An output is also mapped to a value, a column or a data table in Spotfire. When new columns are created, they can be incorporated into an existing data table, if desired. Single value outputs can be mapped to a property and shown in a text area.
Similarity to expression functions
By saving a script as an expression function (only possible with scripts based on TIBCO Enterprise Runtime for R), a statistical calculation can be used in the Spotfire expression language directly, as any other function. This is a way you can enhance the expression language with your own, script-based functions. See How to Create an Expression Function for more information. In contrast to data functions, expression functions are always defined in the context of an analysis and cannot be shared between analyses (except by copying the script from one analysis and saving it in another).