Product: TIBCO Spotfire®
How to use alias name in the color by property of the visualization.
When creating custom expressions in a property control that utilize an aggregation function, by default TIBCO Spotfire will use the same expression as various labels in the visualization, such as color by and the axis label. By using the 'as' modifier in your custom expression you can make these labels more readable.
e g:- Cost instead of Sum(Cost)
The following steps illustrate how
1). Create a text area inside TIBCO Spotfire Analyst and insert a property control like drop-down or list box.
2). Select the "Expressions" option from the set property value through drop down.
3). Click on the "Add" button and write the desired custom expression along with an alias name. Use "as" keyword.
4). After clicking on the "OK" button, right click on the value axis and right click the custom expression- $map("${property control name}", ",")
5). You will see that the name used in the expression is visible in the value axis & hiding the aggregation function name.
6). To use the same name in the color by label, select "Column Name"([Axis.Default.Names]) from the drop-down of Color by property.
Note: For step by step guidance, go through the attached pdf file - "Remove Aggregation Name.pdf".