Logic options

When you add a column to a visual, you can configure it in two ways: Logic and Display. These options are available from the ellipses (...) menu next to the column name in the design bar.

  • Logic – Controls how the column is calculated or aggregated.
  • Display – Controls how the result is formatted and shown in the visual.

Logic tab

The Logic tab lets you choose how to calculate or transform the data in a column before it’s plotted.

Options vary depending on the column type.
Options vary depending on the column type.

Text fields

For categorical or free-text fields, you can only use functions that make sense for non-numeric data:

  • No function – Show raw text values.
  • Count – Count all rows.
  • Count distinct – Count unique text values.
  • Minimum / Maximum – Return the first or last value in sort order (e.g. alphabetically).
  • Edit expression… – Write a custom expression (see calculations in visuals).
  • Remove – Remove the column from the visual.

Numeric fields

For numeric values, you’ll see the full set of aggregations:

  • No function – Show raw values (only available in some visual types).
  • Total / Sum – Aggregate values by summing.
  • Average – Mean of the values.
  • Minimum / Maximum – Lowest or highest value.
  • Count – Count of rows.
  • Count distinct – Count of unique values.
  • Mode, Median – Most common or middle value.
  • Standard deviation (sample / population) – Spread of the values.
  • Variance (sample / population) – Variability of the values.
  • Bin – Bucket values into ranges.
  • Table calculation… – Apply a secondary calculation across the table (see Table calculations).
  • Edit expression… – Write a custom expression (see calculations in visuals).
  • Remove – Remove the column from the visual.

Date fields

For dates and times, you can aggregate by measure or transform into parts of a date:

  • No function – Show raw date values.
  • Minimum / Maximum – Earliest or latest date.
  • Count / Count distinct – Count rows or unique dates.
  • Truncate to date part – Year, Quarter, Month, Week, Day.
  • Extract repeating part – Month of year, Week of year, Day of year, Day of month, Day of week.
  • Table calculation… – Apply a secondary calculation across the table (see Table calculations).
  • Edit expression… – Write a custom expression (see calculations in visuals).
  • Remove – Remove the column from the visual.