• Important Information
  • TIBCO Spotfire Documentation and Support Services
  • TIBCO Spotfire Consumer and TIBCO Spotfire Business Author User's Guide
  • Setting up analyses
    • Data preparation in Microsoft Excel
    • Creating a new analysis from a local file
    • Creating a new analysis from data in the library
    • Creating a new analysis from Google Analytics data
    • Creating a new analysis from Salesforce.com data
    • Adding prompts to a Salesforce.com connection
    • Opening an analysis saved in the library
    • Saving an analysis
    • Adding a data table
    • Adding data from Google Analytics to an analysis
    • Adding data from Salesforce.com to an analysis
    • Working with data connections
      • Supported data sources in Spotfire Business Author On-Premise
      • Opening a connection from 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 width of an individual column in a table
      • Changing widths of all columns in a table simultaneously
      • Specifying the header orientation and header text alignment
      • Specifying the text alignment for table cells
      • 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 width of a separate column in a cross table
      • Changing widths of all columns in a cross table instantly
      • Sorting values in a cross table
        • Sorting values in cross table ignoring the hierarchy
      • 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
      • 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
      • Adjusting the drawing order of markers
      • Showing directions using marker rotation in a scatter plot
    • Creating a map chart
      • Setting map chart properties
      • Adding a map layer
      • Adding a marker layer
        • Adding a rule to a color scheme
        • Showing directions using marker rotation in a map chart
        • Connecting map markers with lines
      • Adding a feature layer
      • Adding a TMS layer
      • Adding a WMS layer
        • Configuring a WMS layer and sublayer
      • Removing a layer
      • Changing layer orders in a map chart
      • Hiding a layer
      • Viewing the geographic coordinates for a location
      • Navigation controls
      • Fixing geocoding issues
      • Supported administrative boundaries
      • Map chart properties
        • Appearance
        • Color
          • Color rule types
        • Copyright
        • Data
        • Drawing order
        • Geographic location
          • Aggregating coordinate-based locations values
        • Jittering
        • Labels
        • Legend
        • Line connection
          • Example: Line connection in a marker layer
        • Map
        • Map type
        • Rendering
        • Rotation
        • Shape
        • Size
        • Title
        • Trellis
        • URL
        • Zoom
    • 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
    • Changing display name for an axis
    • Showing/hiding the legend
    • Specifying the legend appearance
    • Creating intervals of numerical data
    • Showing gridlines
  • Handling data
    • Data panel
    • Getting an overview of your data
      • Column view
        • 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
        • Splitting a column
        • Deleting a column
      • Data table view
        • Changing the name of a data table
        • Replacing a data table
        • Deleting a data table
        • Adding a calculated column
          • Editing a calculated column
        • Adding rows to a data table
          • Editing column matching or other settings for added rows
      • Source view
        • Storing data within the analysis
        • Reloading data
        • Replacing a data source
        • Editing a data connection
        • Removing operations in the Source view
    • 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
  • Filtering data
    • Filtering data using the Data panel
    • 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
  • 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 to details
  • Pages and layout
    • Adding a new page
    • Changing the page layout
      • Changing the page layout using drag and drop
      • Resizing visualizations
      • Changing the look and feel
    • Viewing analysis pages simultaneously
  • Grouping categories
    • Grouping from marked categories
    • Ungrouping categories
    • Handling differently spelled values
  • Adding annotations
    • Minimizing annotations
    • Hiding annotations
    • Removing annotations
    • Use annotations or conversations?
  • 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
  • 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 time periods
    • Setting conditions on axes
    • Custom 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 to Microsoft PowerPoint
  • Sharing analyses
    • Copying a link to an analysis
    • Downloading an analysis
    • Embedding an analysis in a web page
      • Copy link dialog