Numerical column added to Cross Table vertical axis in TIBCO Spotfire is auto-binned by default

Numerical column added to Cross Table vertical axis in TIBCO Spotfire is auto-binned by default

book

Article ID: KB0077113

calendar_today

Updated On:

Products Versions
Spotfire Analyst All Versions

Description

When adding a numerical column to the cross table vertical axis, you would like to see all the values displayed for this column, but the column gets auto-binned by default.
User-added image

Issue/Introduction

Numerical columns that are added to the vertical axis of a Cross Table in the TIBCO Spotfire installed client (TIBCO Spotfire Analyst or TIBCO Spotfire Desktop) are auto-binned by default. It is however possible to remove the binning.

Resolution

This vertical axis is auto-binned by design so that there are not too many nodes on the vertical axis. This is because having a very large number of nodes in the vertical axis hierarchy can be very expensive and can cause performance issues in large data sets.

To un-bin the column, use one of the following two options:

1. Click twice to switch from auto-binned to not-binned:
User-added image

or: 

2. Un-check the auto-bin box in the column selector dialog:
User-added image

Additional Information

Doc: How to Use the Cross Table