Chart View

The Chart view transforms your database entries into interactive charts — no export, no external tool needed. Perfect for quick analysis directly inside your database.

Chart types

Type	Best for
Bar	Comparing categories (status, type, assignee)
Donut	Proportions and shares at a glance
Line	Trends over time (Date columns)

Configuration

Group by

Choose the column to group data by. Every column is available — except File, Image and Button, which have no readable key. Specifics:

Select / Multi-select — each option becomes a group; an entry with two options counts in both
Relation — one group per linked row, labelled with its title
Date, Created at, Modified at — grouped by month (e.g. Apr 2026)
Checkbox — two groups: Yes / No
Person — one group per member, showing the name instead of an ID
Formula, Rollup, Lookup, Count — the computed value becomes the key

Value (aggregation)

Determines what is shown on the Y-axis (bar/line) or as a segment (donut):

Aggregation	Description
Count	Number of entries per group
Sum	Sum of a column’s values
Average	Mean
Min	Smallest value
Max	Largest value

Any column a number can be read from works as the value: Number, Rating, Duration, Auto-number, Checkbox (yes = 1) as well as Formula, Rollup, Lookup and Count. For relations the chart counts the links — “how many shots are attached to this shoot day”.

Filters & sorting

The Chart view respects all active filters and sorts. Use the toolbar to filter as usual — the chart updates instantly.

Examples

Shot status overview

Group by: Status (Select)
Value: Count
Chart type: Donut → Shows at a glance how many shots are “Open”, “In Progress”, and “Done”.

Revenue by month

Group by: Invoice date (Date)
Value: Sum → Amount (Number column)
Chart type: Line → Revenue trend over time.

Tasks per team member

Group by: Assignee (Select)
Value: Count
Chart type: Bar → Workload comparison across the team.