Feature Request: Add feature to list distinct values when filtering

[mxjucdavishealth]

Type: Feature Request

Behaviour

Unable to get a list of distinct values when filtering on a specific column.

Expected vs. Actual

Expected: Filter component returns a list of distinct values when fitering on a specific column.

Acutal: Filter component does not have the ability to return a list of distinct values when fitering on a specific column.

Steps to reproduce:

1. View data
2. Select specific column you wish to filter
3. Select Add filter
4. Select a condition. For example, "Equal to". Here, it would be helpful to the filter component to return a list of distinct values from the column you plan to apply a filter on.

Diagnostic data

VS Code version: Version: 1.92.0 (user setup) Commit: b1c0a14de1414fcdaa400695b4db1c0799bc3124 Date: 2024-07-31T23:26:45.634Z Electron: 30.1.2 ElectronBuildId: 9870757 Chromium: 124.0.6367.243 Node.js: 20.14.0 V8: 12.4.254.20-electron.0 OS: Windows_NT x64 10.0.19045

• Jupyter extension version: 2024.7.0
• Python extension version: 2024.12.1
• .NET Install Tool for Extension Authors extension version: 2.1.1
• Python package dependencies:

{
  "installed": {
    "pandas": "2.2.2"
  },
  "required": {
    "pandas": "1.2.0"
  },
  "unsatisfied": []
}

• Entrypoint: JupyterNotebookToolbar
• Active mode: dataWrangler

Extension version: 1.6.0 VS Code version: Code 1.92.0 (b1c0a14de1414fcdaa400695b4db1c0799bc3124, 2024-07-31T23:26:45.634Z) OS version: Windows_NT x64 10.0.19045 Modes:

[pwang347]

Hi @mxjucdavishealth, thanks for opening this request! We've added to our backlog and will let you know when there are any updates.