Products | Versions |
---|---|
Spotfire Analyst | All Versions |
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.
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.