Setting display values based on other columns
Sometimes, you might want to show other values than the ones that actually define an axis as the display values. Display values can easily be configured in the expanded Data in analysis flyout.
Display values are configured in the expanded Data in analysis flyout. Only string columns or expressions are allowed as display values.
When defining display values and there is a single matching string column available in the target data table, you can choose to show just the value from the other column, or a combination of the old value and the display value from the other column:
It is possible to specify similar configurations even if the shortcut options are unavailable. Do it by defining a custom expression on the display value column (such as, Concatenate([Employees].[Employee ID],": ",[Employees].[Name])). Note that expressions that mix columns from multiple data tables are not supported.
To use column values from a different data table, there must be a column match between the two data tables. This is often created automatically (e.g., if the name and data type of two ID columns in the data tables are the same) but it is also possible to configure specific column matches using Spotfire Analyst. See Multiple Data Tables in One Visualization in the Spotfire Analyst help for general information about matching data tables.
- On the authoring bar, click Data in analysis , and click on the column you want to change the display values for.
- In the expanded flyout, make sure that Details on selected column is selected.
In the lower part of the expanded flyout, click the column selector under
If there is more than one data table in the analysis, and a column match is available, you will see a drop-down list at the top of the expanded column selector that lets you choose a data table. If you have a single data table in the analysis you can only choose columns from that data table. See Choosing the data to analyze and Choosing how to load the data for help on how to add another data table to the analysis.
In the upper part of the column selector, choose the data table from which to pick the values for the display values.
If you cannot see any columns in the list, you might not have a column match defined. See Column Matching in the Spotfire Analyst help for more information.
Click on the column to provide the display values.
You can also define a custom expression for the display values. For example, Concatenate([Employees].[Firstname], " ",[Employees].[Last name]). See below for more details.Visualizations and applicable filters are updated to show the display values instead of the original values.
In this example, you have two different data tables in the analysis; the first one contains the salaries for a number of employees, identified using the employee number:
The second data table contains a mapping of the employee number to the first name and last name of the employees:Data in analysis flyout:
See also Sorting columns with display values.
Using a different version of Spotfire?This help describes the web client version of Spotfire on TIBCO Cloud™. If you're looking for documentation for the installed client or other versions of Spotfire, visit the TIBCO Documentation Portal.