How to use multiple columns as labels in a visualization in TIBCO Spotfire

How to use multiple columns as labels in a visualization in TIBCO Spotfire

What to do when there are two or more columns that you would like to be able to have as the labels for a visualization. You cannot select multiple fields in the Labels tab in the visualization's Properties dialog, but you can create a custom expression for the label, using the concatenate() function.  For example:

First(Concatenate([Field 1]," ",[Field 2]))

Or, to insert a line break:

First(Concatenate([Field 1],"\n",[Field 2]))

Note that all fields in the concatenate() expression must be of the same DataType, so if you want to combine Integers with Strings, surround the Integer column with the string() function.  For example:

First(Concatenate(String([Field 1])," ",[Field 2]))

The expression used for defining labels requires an aggregation method, which is why First() is being used in this example.  Note that the data may not work well with the First() function so you may need to substitute another aggregation function that works better with your particular data set. Doc: Scatter Plot Properties – Labels

• https://docs.tibco.com/pub/sfire-analyst/10.3.1/doc/html/en-US/TIB_sfire-analyst_UsersGuide/scat/scat_properties_labels.htm

Doc: 3D Scatter Plot Properties – Labels

• https://docs.tibco.com/pub/sfire-analyst/10.3.1/doc/html/en-US/TIB_sfire-analyst_UsersGuide/3d_scat/3d_scat_properties_labels.htm

Doc: Marker Layer Settings – Labels

• https://docs.tibco.com/pub/sfire-analyst/10.3.1/doc/html/en-US/TIB_sfire-analyst_UsersGuide/map_marker/map_marker_layer_settings_labels.htm