Important Information
TIBCO Spotfire Documentation and Support Services
This is Spotfire
The user interface
Load data
Know the data
Visualize data
Analyze data
Make calculations on the data
Share with others
Loading data
Choosing the data to analyze
Creating a new analysis from data in the library
Creating a new analysis from a local file
Adding more data
Choosing how to load the data
Load methods
Accessing data in databases
Supported data sources
Accessing data from Salesforce
Adding prompts to a Salesforce connection
Accessing data from Google Analytics
Accessing data from other external data sources
Data preparation in Microsoft Excel
Searching the library
Opening an analysis saved in the library
Creating a visualization
Creating a table
Changing the order of the columns in a table
Hiding a column in a table
Showing hidden columns in a table
Changing height and width in tables
Specifying the header orientation and header text alignment
Specifying the text alignment for table cells
Specifying text color, background color, and font style in a table
Sorting a table
Creating a cross table
Displaying totals
Displaying grand totals for columns in cross tables
Displaying grand totals for rows in cross tables
Showing subtotals in cross table columns
Displaying grand totals and subtotals as sums of the cell values
Changing height and width in tables
Sorting values in a cross table
Sorting values in cross table ignoring the hierarchy
Styling in the cross table
Specifying header orientation and header text alignment for multiple headers
Specifying header orientation and header text alignment for an individual header
Specifying horizontal text alignment for cross table cells
Specifying text color and background color for multiple headers
Specifying text color and background color for an individual header
Specifying text color and background color for cross table cells
Specifying text color, background color, and font style for subtotals and grand totals
Marking values in cross tables
Creating a bar chart
Creating a stacked bar chart
Creating a side-by-side bar chart
Creating a 100% stacked bar chart
Creating a horizontal bar chart
Showing values of bars
Sorting bars by value
Sorting bar segments by value
Showing only top bars
Creating a waterfall chart
Showing intermediate total bars
Hiding total bars
Showing customized intermediate total bars
Showing values of bars and blocks
Showing waterfall per categorical color
Showing waterfall per category on the category axis
Continuing a waterfall over trellis panels
Creating a line chart
Marking in line charts
Creating a combination chart
Sorting the combination chart
Switching between bars and line series
Creating a pie chart
Sorting pie sectors by size
Creating a scatter plot
Using marker appearance to add more information
Using tiled markers
Creating a density plot
Adjusting the drawing order of markers
Showing directions using marker rotation in a scatter plot
Creating a map chart
Setting map chart properties
Adding layers
Adding a marker layer
Showing directions using marker rotation in a map chart
Adding a feature layer
Adding an image layer
Moving and resizing images
Positioning markers on an image background
Adding a map layer
Adding a TMS layer
Adding a WMS layer
Configuring a WMS layer and sublayer
Duplicating a layer
Working with layers
Viewing the geographic coordinates for a location
Navigation in the map chart
Fixing geocoding issues
Aggregating coordinate-based locations values
Example of a line connection in a marker layer
Creating a treemap
Navigating in a treemap hierarchy
Creating a KPI chart
Adding a new KPI to a KPI chart
Basic example of a KPI
KPI showing absolute and relative profit
Specifying generic KPI chart properties
Specifying accepted tile width
Showing sparklines
Sorting tiles alphabetically
Sorting tiles by performance
Creating a parallel coordinate plot
Displaying actual values in the parallel coordinate plot
Creating a histogram
Creating a trellised visualization
Visualizations trellised by data columns
Trellis options
Duplicating a visualization
Modifying a visualization
Selecting columns on an axis
Other options than columns in column selectors
(Column Names)
(Subsets)
(Row Number)
(Row Count)
(Axis values)
Changing the column order on an axis
Specifying time hierarchies
Creating hierarchies
Aggregating data
Adjusting scales on axes
Adding a zoom slider
Changing display name for an axis
Showing/hiding the legend
Specifying the legend appearance
Grouping categories
Grouping from marked categories
Ungrouping categories
Handling differently spelled values
Creating intervals of numerical data
Showing gridlines
Handling data
Data in analysis
The expanded data in analysis flyout
Changing the categorization of a column
Changing the formatting of a column
Custom formatting of numeric columns
Custom formatting of date and time columns
Custom formatting of timespan columns
Changing the data type of a column
Replacing empty values in a column
Changing a column name
Setting display values based on other columns
Sorting columns with display values
Splitting a column
Deleting a column
Changing the default sort order of values in a column
Unpivoting columns
Replacing a value
Replacing all occurrences of a value in a column
Replacing a specific value in a column
Replace value – more information
Data canvas
Changing the name of a data table
Replacing a data table
Deleting a data table
Adding rows to a data table
Editing column matching or other settings for added rows
Adding columns to a data table
Editing settings for added columns
Storing data within the analysis
Reloading data for a single data source
Replacing a data source
Removing operations in the data canvas
Removing a data source from a data table
Editing a data connection
Reloading data
Filtering data
Filtering data using the Data in analysis flyout
Filtering data using the Filters panel
Filter types
Using range filters
Using item filters
Using check box filters
Using radio button filters
Using text filters
Using list box filters
Using hierarchy filters
Search in hierarchy filters
Changing filter type
Creating a filter transformation
Marking
Marking items
Marking items using the legend
Unmarking items
Reapplying markings when reloading data
Working with colors
Changing color of visualization items
Adding color rules
Editing color rules
Changing order of color rules
Removing color rules
Adding color schemes
Analyzing data
Exploring data across visualizations
Displaying item details
Drilling down into details
Specifying what to show when no data is marked
Zooming into visualization details
Pages and layout
Changing page navigation method in an analysis
Hiding pages
Adding a new page
Changing the page layout
Changing the page layout using drag and drop
Resizing visualizations
Changing the look and feel
Custom themes overview
Custom theme settings
Viewing analysis pages simultaneously
Adapting layout to different screen sizes
Modifying responsive layouts
Specifying minimum acceptable page size
Locking the size of certain visualizations
Customizing the toolbar
Adding annotations
Minimizing annotations
Hiding annotations
Removing annotations
Use annotations or conversations?
Error bars
Adding error bars
Collaborating when analyzing data
Starting a conversation
Limitations in captured analysis states
Replying in a conversation
Deleting a conversation
Deleting a reply
Viewing conversations
Minimizing conversations
Getting link for sharing
Use annotations or conversations?
Using bookmarks
Adding a bookmark
Applying a bookmark
Updating a bookmark
Renaming a bookmark
Deleting a bookmark
Making a bookmark public
Making a bookmark private
Copying a link to a bookmark
Making your own calculations
Calculated columns
Adding a calculated column
Editing a calculated column
Evaluations of expressions
Examples of calculated columns
Simple conversion and formula calculations
Calculations of time differences
Ranking
Calculated columns based on conditions
Custom expressions
Applying a custom expression
Examples of custom expressions
Showing fewer digits on an axis by dividing a result with 1000
Calculating the sum of two or more columns
Showing the difference between the values in two columns
Calculating profit in percent
Calculating time periods
Setting conditions on axes
Slicing and marker concepts
Using OVER statement to reference data slices
Using OVER statements in calculated columns
Node navigation
All()
Previous()
Next()
AllPrevious()
LastPeriods()
AllNext()
Parent()
Intersect()
PreviousPeriod()
NextPeriod()
ParallelPeriod()
Expression language details
Operators
Operator precedence
Functions
Binning functions
Conversion functions
Cast method
Date and time functions
Keywords in expressions
Logical functions
Math functions
OVER functions
Property functions
Ranking functions
Spatial functions
Statistical functions
Text functions
Data types
Exporting your analysis
Exporting to PDF
What to export
General export settings
Exporting an entire analysis
Exporting a visualization
Exporting a visualization and include non-visible content
Exporting a single analysis page
Exporting specific analysis pages
Exporting Details-on-demand
Exporting a prepared report
Prepared reports
Report settings
Contents
Headers and footers
PDF page setup
Preparing a report
Repeating pages and visualizations over bookmarks
Repeating pages and visualizations over filter values
Editing what is repeated over in a PDF export
Exporting to Microsoft PowerPoint
Exporting visualization to image
Find
Saving an analysis
Sharing analyses
Copying a link to an analysis
Downloading an analysis
Embedding an analysis in a web page
Optimizing a dashboard using URL parameters
Copy link dialog