ADVIZOR Help
v7.2+
v7.2+
  • Introduction
  • Overview
    • ADVIZOR Help
    • ADVIZOR Overview
      • Analyst
      • Analyst/X
      • Data Blender
      • Desktop Navigator
      • Server AE
      • Managed Hosting
  • Using ADVIZOR
    • File Ribbon
      • Open an Existing ADVIZOR Project
      • Restore a Backup Project Version
      • Save a Project
      • Template Library
      • Update Expired Credentials
    • Analyze Ribbon
      • Select and Exclude Data
      • Flight Recorder
      • Set Coloring
        • Use Color Scale
        • Use Color By
        • Color Legend
      • Navigation Pane
    • Author Ribbon
      • Charts, Pages, and Dashboards
        • Composing Pages with Charts
        • Page Gallery
      • Load Data
        • Load New Data Using the Data Wizard
        • Load Text Data
        • Load Microsoft Excel Data
        • Load Microsoft Access Data
        • Load SQL Server Data
        • Load Oracle Data
        • Load a Database via ODBC
        • Manage Data Sources
        • Replace an Existing Data Source
      • Design Pages
        • Create Navigation Pane Content
        • Rearrange Charts
        • Change Chart Fonts
      • Use Color Models
        • Manage Color Models
        • Assign Color Models to Pages
        • Color Workshop
        • Identify How Color Is Applied to Data
        • Uncolorable Tables
      • Configure Charts
        • Property Explorer
        • Link Unmatched Rows
        • Show Missing Values
        • Use Polygon Map Format
        • Use FocusFormat Property
      • Condition Data
        • Project Workshop
        • Use the Expression Builder
        • Use the Link Wizard
        • Delete a Link
        • Date Formatter
        • Configure Data Hierarchies
      • Explore Data Usage
      • Identify Issues with Legacy Projects
      • Data Pool Visualization
    • Model Ribbon
      • Predictive Analytics: Analyst/X
      • Analytics Process
        • Bin a Categorical Field
        • Date Fields
        • Zip Codes
      • Predictive Modeling Pane
      • Configuring a Model
      • Managing Models
    • Share Ribbon
      • Share Results
      • Export Tables
      • Deployment and ADVIZOR Server
        • ADVIZOR Server Dashboards
        • Publishing to ADVIZOR Server
        • Server Security
        • Credential Based Filters
        • Embedding Data in a Project
  • Charts and Visual Discovery
    • Charts Overview
      • Bar Chart
        • Inserting a Bar Chart
        • Bar Chart Toolbar
      • Counts
        • Inserting a Counts
        • Counts Toolbar
      • Data Constellation
        • Inserting a Data Constellation
        • Data Constellation Toolbar
      • Data Sheet
        • Inserting a Data Sheet
        • Data Sheet Toolbar
      • Heat Map
        • Inserting a Heat Map
        • Heat Map Toolbar
      • Histogram
        • Inserting a Histogram
        • Histogram Toolbar
      • Line Chart
        • Inserting a Line Chart
        • Line Chart Toolbar
      • Map
        • Inserting a Map
        • Map Toolbar
      • Multiscape
        • Inserting a Multiscape
        • Multiscape Toolbar
      • Parabox
        • Inserting a Parabox
        • Parabox Toolbar
      • Pie Chart
        • Inserting a Pie Chart
        • Pie Chart Toolbar
      • Scatterplot
        • Inserting a Scatter Plot
        • Scatter Plot Toolbar
      • Summary Sheet
        • Inserting a Summary Sheet
        • Summary Sheet Toolbar
      • Text Box
        • Inserting a Text Box
        • Text Box Toolbar
      • Text Filter
        • Inserting a Text Filter
        • Text Filter Toolbar
      • Time Table
        • Inserting a Time Table
        • Time Table Toolbar
    • Recommended Chart Use
    • Visual Discovery
      • Using Colors
      • Selection
      • Managing Viewpoint
      • Missing Values
    • User Interfaces
      • Context Menu
      • Keyboard
  • Release Notes
    • What's New
      • Release 7.2
      • Release 7.1
      • Release 7.0
      • Release 6.8
      • Release 6.7
      • Release 6.6
      • Release 6.4
      • Release 6.3
      • Release 6.2
      • Release 6.2.2
      • Release 6.0
      • Release 5.9
      • Release 5.8.2
      • Release 5.7
      • Release 5.6.2
      • Release 5.6.1
      • Release 5.51
      • Release 5.5
      • Release 5.4.1
      • Release 5.4
      • Release 5.3
      • Release 5.22d
      • Release 5.2 SalesAdvizor
      • Release 5.1
      • Release 5.0.3
      • Release 5.0
    • If You Need Additional Help
    • Copyright
Powered by GitBook
On this page
  • Bin a Categorical Field
  • Creating a New Model
  1. Using ADVIZOR
  2. Model Ribbon
  3. Analytics Process

Bin a Categorical Field

PreviousAnalytics ProcessNextDate Fields

Last updated 5 years ago

Bin a Categorical Field

Categorical fields are modeled as a separate field for each distinct category. So a field with a large number of categories cannot be modeled. Use this dialog to see if the field can be reduced to a smaller number of categories by combining together small occurance categories. This is accessible through the Configure dialog.

This dialog is an interface on top of the "bin()" function. You can also create a "bin()" expression directly.

See for a detailed discussion of the modeling capabilities in ADVIZOR AnalystX. Review the overall Analytics to see how this dialog fits into it.

Creating a New Model

Bin a categorical field like this:

  1. Categorical Fields: This box lists all categorical fields in the table chose for modeling. Click a field name to see more details about it.

  2. Original Categories: The number of unique categories in the original field.

  3. After Binning: The number of unique categories after the field is binned. Binning is done using the Create button (below).

  4. Group Name: The name used for the group formed from low frequency categories.

  5. Coverage: This is the percentage of the data with the highest occurance categories where the categories are unchanaged. Data is aggregated by row count and ordered; after this threshold, all remaining bins are give the "other" Group Name

    This works best if there are a small number of categories that are common and a large number of low occurrance categories. The low occurance categories are summarized into a single, new category.

  6. Binned Field: The name of the new field produced. This cannot be modified by the user.

  7. Create: Create the new field with reduced categories.

  8. Remove: Remove a new field that was created. This happens immediately and is not undone by Cancel (below).

  9. Help: Display assistance on using this dialog.

  10. OK: Close the dialog and update the Model Configuration dialog with any changes.

  11. Cancel: Close the dialog and discard any changes.

If OK is used to close the dialog, any newly binned fields are added to the Model Configuration, and the base field is removed. Cancel causes all additions to be forgotten. Remove actions, however, are not reversed by Cancel.

This dialog creates a "bin()" expression to do the binning, which is recorded with the project so that it will be run when the project is refreshed.

See Also:

Overview
Process
Predictive Modeling View
Configure Model
Expression Builder
Predictive Analytics
process