Skip to main content

Visualization Properties in Expressions

Quoted from Spotfire manuals

Visualization Properties in Expressions


In some cases, you may want to use the expression or the display name currently set on an axis as a dynamic part of another expression, so that it changes with your selections. For example, this may be interesting in a visualization title or in a tooltip or label. You may also want one axis to be automatically set to use the same expression as the one set on another axis.
There are a number of different "axis expressions working like properties" available in the visualizations. These properties exist only in the context of a visualization and they have values that are defined by the currently used settings in the visualization. For example, a scatter plot can expose the display name of its X and Y-axis expressions as properties and these can in turn be used to set the visualization title.
The syntax to use is ${Axis.Axis Name.DisplayName} and ${Axis.Axis Name.Expression}, for the display name and the underlying expression, respectively. For example, if the Axis Name is "X", the expression should refer to ${Axis.X.DisplayName} or ${Axis.X.Expression}. Note that the actual axis names to use may be different in two similar looking visualizations, see below. The ${DataTable.DisplayName} property can be used in all visualizations to retrieve the name of the main data table used in the visualization.
These properties can be used the same way as other types of properties. All of the display name-properties listed below also have a corresponding property for the actual expression.

Visualization
Axis Name Used in Expression
Axis (Property) it Represents
[All visualizations]
DataTable.DisplayName
The name of the main data table used in the visualization
Cross Table
Axis.Columns.DisplayName
Axis.Measures.DisplayName
Axis.Rows.DisplayName
Horizontal axis
Cell values
Vertical axis
Graphical Table
Axis.Rows.DisplayName
Graphical table rows
Bar Chart
Axis.Color.DisplayName
Axis.Columns.DisplayName
Axis.Pages.DisplayName
Axis.Panels.DisplayName
Axis.Rows.DisplayName
Axis.X.DisplayName
Axis.Y.DisplayName
Color by
Trellis columns
Trellis pages
Trellis panels
Trellis rows
Category axis
Value axis
Line Chart
Axis.Line.DisplayName
Axis.Color.DisplayName
Axis.Columns.DisplayName
Axis.Pages.DisplayName
Axis.Panels.DisplayName
Axis.Rows.DisplayName
Axis.X.DisplayName
Axis.Y.DisplayName
Line by
Color by
Trellis columns
Trellis pages
Trellis panels
Trellis rows
X-axis
Y-axis
Combination Chart
Axis.Color.DisplayName
Axis.Columns.DisplayName
Axis.Pages.DisplayName
Axis.Panels.DisplayName
Axis.Rows.DisplayName
Axis.X.DisplayName
Axis.Y.DisplayName
Color by
Trellis columns
Trellis pages
Trellis panels
Trellis rows
X-axis
Y-axis
Pie Chart
InnerAxis.Color.DisplayName
InnerAxis.SectorSize.DisplayName
Color by
Sector size by
Scatter Plot
Axis.Color.DisplayName
Axis.Columns.DisplayName
Axis.Marker.DisplayName
Axis.Pages.DisplayName
Axis.Panels.DisplayName
Axis.Rows.DisplayName
Axis.Size.DisplayName
Axis.X.DisplayName
Axis.Y.DisplayName
InnerAxis.Color.DisplayName
InnerAxis.SectorSize.DisplayName
Color by
Trellis columns
Marker by
Trellis pages
Trellis panels
Trellis rows
Marker size by
X-axis
Y-axis
Pie sector color
Pie sector size
3D Scatter Plot
Axis.Color.DisplayName
Axis.Columns.DisplayName
Axis.Marker.DisplayName
Axis.Pages.DisplayName
Axis.Panels.DisplayName
Axis.Rows.DisplayName
Axis.Size.DisplayName
Axis.X.DisplayName
Axis.Y.DisplayName
Axix.Z.Display.Name
Color by
Trellis columns
Marker by
Trellis pages
Trellis panels
Trellis rows
Marker size by
X-axis
Y-axis
Z-axis
Map Chart
Axis.Color.DisplayName
Axis.Columns.DisplayName
Axis.Marker.DisplayName
Axis.Pages.DisplayName
Axis.Panels.DisplayName
Axis.Rows.DisplayName
Axis.Size.DisplayName
Axis.X.DisplayName
Axis.Y.DisplayName
InnerAxis.Color.DisplayName
InnerAxis.SectorSize.DisplayName
Axix.Identifier.DisplayName
Color by
Trellis columns
Marker by
Trellis pages
Trellis panels
Trellis rows
Marker size by
X-axis
Y-axis
Pie sector color
Pie sector size
Coloring data table identifier
Treemap
Axis.Color.DisplayName
Axis.Columns.DisplayName
Axis.Pages.DisplayName
Axis.Panels.DisplayName
Axis.Rows.DisplayName
Axis.Size.DisplayName
Axis.Hierarchy.DisplayName
Color by
Trellis columns
Trellis pages
Trellis panels
Trellis rows
Size by
Hierarchy
Heat Map
Axis.Columns.DisplayName
Axis.Pages.DisplayName
Axis.Panels.DisplayName
Axis.Rows.DisplayName
Axis.X.DisplayName
Axis.Y.DisplayName
Axis.Measures.DisplayName
Trellis columns
Trellis pages
Trellis panels
Trellis rows
X-axis
Y-axis
Cell values
Parallel Coordinate Plot
Axis.Line.DisplayName
Line by
Summary Table
Axis.CategoryAxis.DisplayName
Categorization

Comments

Popular posts from this blog

Using Accordions in Spotfire Text Areas

Spotfire 6.0 provides great tools for quickly building your dashboard, but here we will learn to spice up things with the help of new 6.0 text area. If you are not aware the new 6.0 Text area supports HTML, Javascript and CSS. This opens up possibilities for doing a lot more with the text area. Some of the basic stuff can be seen here http://spotfire.tibco.com/qrt/UBSAN/presentation.html?pcode=100044   One of the cool things you can do is build an accordion panel in the text area for better utilization of the valuable screen real estate and helping the overall experience.(Watch the 0:15 second video below to see how accordion works - Sorry for the jitter in the video. The screen recorder does not record fast enough) Here is the html behind the text area : Please note that Spotfire controls are automatically created when you add text area controls, like filters, drop down lists etc. <DIV id="myaccordion"> <H3>Analysis Details</

Calendar Chart in Spotfire

I recently had a colleague asking me to show him the data in a calendar format.. Something like this I basically used a scatterplot for this.  You can check out the original DXP here  http://bit.ly/spotcalendar Some key settings to make it a calendar. Please note Order date is the date of interest here These expressions are out of the box expressions, no need to handcode them, but select them in the axis value  X Axis    <BinByDateTime([Order Date],"DayOfWeek",0)> Y Axis    Week([Order Date]) Trellis into panels   <BinByDateTime([Order Date],"Year.Quarter.Month",2)> Manual layout 4 X 3 Labels  UniqueConcatenate(DayOfMonth([Order Date])) Shape Tiled Markers Marker by   <UniqueConcatenate([Order Date])> Happy plotting your calendar!!!

Spotfire Auto Save for recovery

This is an extension I build to auto save local copies of currently open DXP every 15 minutes.. I have tested briefly and it seems to be doing its job, please please please try and test it if you can access a server and deploy.. Key Notes - This add-on will Auto Save Files while only in Spotfire Analyst Client. The save time is hard coded for every 15 minutes. Files are saved only if they are changed or user has done some actions like marking, filtering etc. The Files are saved in temporary location of the system, generally which will be like C:\Users\<username>\AppData\Local\Temp\Spotfire AutoSave If a Library file is opened it will be saved on your local machine under the temp path C:\Users\<username>\AppData\Local\Temp\Spotfire AutoSave\Library Content\ Library path will be replicated in this autosave location. e.g. C:\Users\<username> \Local\Temp\Spotfire AutoSave\LibraryContent\mylibraryfolder\mylibraryfilename_mmddyyyy_HH