Add Column Cardinality Information to Data in Analysis Flyout

Problem Statement

Currently, the Data in Analysis flyout in Spotfire does not display comprehensive column cardinality information for all data types. Specifically:

• Numeric columns: No count information is displayed

• Categorical columns: Only shows unique count (#unique), but lacks total value count

Proposed Enhancement

Add column cardinality metrics to the Data in Analysis flyout for all column types, including:

• Total count of values (including duplicates)

• Unique count of values (distinct values)

• Null/missing value count

This information should be consistently available across all data types (numeric, categorical, date/time, etc.).

Business Value

• Data Quality Control: Enables quick assessment of data completeness and distribution

• Improved Workflow Efficiency: Reduces need to create separate calculations or visualizations for basic data profiling

• Enhanced User Experience: Provides immediate insights into data characteristics during analysis setup

Current Workaround

Users must currently use UniqueCount aggregation functions or create custom calculations to obtain this information, which adds unnecessary steps to the analysis workflow.

Use Case

Data analysts and scientists frequently need to understand the cardinality of their datasets for:

• Data quality assessment

• Feature selection in machine learning workflows

• Understanding data distribution patterns

• Identifying potential data issues early in the analysis process