Handling data
Your data is the most important thing when you are working with Spotfire visual analytics. If you are familiar with the data you want to analyze, chances increase that you can set up good visualizations and find interesting conclusions during the analysis.
About this task
- Data in analysis
The Data in analysis flyout shows a structured list of all data columns in a data table, that is, it gives you an overview of your data. It can be the starting point for configuring visualizations, because from the flyout, you can drag columns to drop targets in the middle of the visualizations and to the visualization axes. You can also filter to certain values (because each column in the panel is associated with a filter) and you can get recommendations about suitable visualizations and other operations from the expanded flyout. - Data canvas
The Data canvas (the source view) shows how data has been added to the data table, and whether any other modifications have been done to obtain the final data table. Each object in the upper part of the data canvas is called a node, and it represents a data source, an operation where data from two sources have been combined, a data function, or similar. In the source structure, you can click on different nodes to see what has been done with the data in that step. This can help you get an insight in how the final data table, used in the analysis, was created. You can also use the data canvas to change settings for different nodes or operations, or to reload data from different sources. - Data tables in Spotfire
The data table is a central concept in Spotfire. All visualizations you create are based on data from one or more data tables in the analysis. You automatically get a data table when you add the first data to an analysis, but the data table can often be refined by adding more data from other sources (as rows or columns), by adding calculated columns or hierarchies, applying transformations, and so on. You can work with your data table in the data canvas. An analysis can contain one or more data tables and all data tables are saved when the analysis is saved. - Replacing data
There are several different methods you can use to replace data in Spotfire. If linking the data to the source is not enough, you can select to replace a data source within a data table, or, to replace the entire data table. You can also replace the values in a column using a transformation, or a single value within a column using one of the Replace Value-options. - Document properties, column properties and data table properties
Properties are metadata about different parts of an analysis file. Some of the properties are created automatically by Spotfire or by other tools that produce data, but when you are working with an analysis file in a Spotfire client, you also have the option to add custom properties to the analysis. Properties can be used inside expressions in different parts of an analysis, such as in calculated columns or custom expressions, and also be used with property controls in text areas (added using the installed client). Data functions can use properties both as inputs and outputs. - Data functions and the f(x) flyout
In addition to the possibility to add your own calculated columns or custom expressions to an analysis, a business author might also have access to data functions that have been created by a script author using Spotfire Analyst and saved in Spotfire library. These data functions can be used to add more advanced calculations and use scripts based on different programming languages in the analysis.
- Data in analysis
The Data in analysis flyout shows a structured list of all data columns in a data table, that is, it gives you an overview of your data. It can be the starting point for configuring visualizations, because from the flyout, you can drag columns to drop targets in the middle of the visualizations and to the visualization axes. You can also filter to certain values (because each column in the panel is associated with a filter) and you can get recommendations about suitable visualizations and other operations from the expanded flyout. - Data canvas
The Data canvas (the source view) shows how data has been added to the data table, and whether any other modifications have been done to obtain the final data table. Each object in the upper part of the data canvas is called a node, and it represents a data source, an operation where data from two sources have been combined, a data function, or similar. In the source structure, you can click on different nodes to see what has been done with the data in that step. This can help you get an insight in how the final data table, used in the analysis, was created. You can also use the data canvas to change settings for different nodes or operations, or to reload data from different sources. - Data tables in Spotfire
The data table is a central concept in Spotfire. All visualizations you create are based on data from one or more data tables in the analysis. You automatically get a data table when you add the first data to an analysis, but the data table can often be refined by adding more data from other sources (as rows or columns), by adding calculated columns or hierarchies, applying transformations, and so on. You can work with your data table in the data canvas. An analysis can contain one or more data tables and all data tables are saved when the analysis is saved. - Replacing data
There are several different methods you can use to replace data in Spotfire. If linking the data to the source is not enough, you can select to replace a data source within a data table, or, to replace the entire data table. You can also replace the values in a column using a transformation, or a single value within a column using one of the Replace Value-options. - Document properties, column properties and data table properties
Properties are metadata about different parts of an analysis file. Some of the properties are created automatically by Spotfire or by other tools that produce data, but when you are working with an analysis file in a Spotfire client, you also have the option to add custom properties to the analysis. Properties can be used inside expressions in different parts of an analysis, such as in calculated columns or custom expressions, and also be used with property controls in text areas (added using the installed client). Data functions can use properties both as inputs and outputs. - Data functions and the f(x) flyout
In addition to the possibility to add your own calculated columns or custom expressions to an analysis, a business author might also have access to data functions that have been created by a script author using Spotfire Analyst and saved in Spotfire library. These data functions can be used to add more advanced calculations and use scripts based on different programming languages in the analysis.