Using Native Array Columns in Luzmo

Why This Matters

Arrays let you store multiple values in one place — like a list of tags or multiple categories for a product.

With Luzmo’s new support for arrays, you can:

• Easily group and analyze these multi-value fields in charts.
• See the complete array data in regular tables for accurate reporting and context.

This feature opens up richer ways to explore and understand your data!

What’s New?

• Native array support: Luzmo can now work directly with array data types in your database, like lists of tags, categories, or other grouped values.
• Currently supported data sources:
  • PostgreSQL
  • ClickHouse
  • Custom Plugin connectors (exposing Array column types and querying Array columns)
• Only native arrays: We support arrays that are stored as real array types in the database, not JSON or other custom formats.

How It Works

Visualizations and Pivot Tables

• In charts and pivot tables, array columns are automatically split into their individual items (this is called “unnesting”).

  → This means you can group by these items, count how often they appear, or analyze them just like other supported columns (like numeric, hierarchy, date, or datetime).

Regular Tables

• In regular tables, array columns remain nested.

This combination makes it easy to both break down arrays for analysis and see them in their original format.

→ This way, you see the entire list of values for each row exactly as it appears in your database.

Filtering on Array Columns

At the moment, filtering on array columns is only supported via interactivity filters (Filter Items).

Interactivity Filters (Filter Items)

• You can filter array columns using dropdowns, checkboxes, or search widgets that are added to your dashboard as Filter Items.
• These filters work with unnested values: each item in the array is treated as an individual value.
• Example: If a product has the tags ["home", "tech"] and the user selects "tech" in the filter, the product will be included in the results.

Not supported in:

• Dashboard-level filters
• Chart-level filters
• Embed filters
• Alert conditions and triggers

These filters currently do not support array columns and will not allow selection of array fields

⚠️ Important Limitations

• This feature only works for PostgreSQL and ClickHouse today.
• Only works with native array types in the database (not JSON or other types).
• Filtering on array columns is currently only supported via interactivity filters (Filter Items).
• Array columns are not supported in Derived Columns or Aggregation Formulas.
• Period-over-Period (PoP) analysis is not supported on array columns.