Table Builder
The Table Builder is the core UI of the platform. It lets you construct arbitrary tabular reports from your event data — without writing SQL.
The Table Builder is the core UI of the platform. It lets you construct arbitrary tabular reports from your event data — without writing SQL.
How it works
A table is defined by six parameters. Configure any combination and click Run.
1. Event filter
Select which event types to include. You can pick one or multiple. The available list is pulled from your project's auto-discovered event schema.
2. Columns
Choose what to show in the table. Three column types are available:
| Type | Examples |
|---|---|
| System fields | timestamp, user_id, session_id, source |
| Event properties | Any key from properties of the selected events |
| Aggregations | count, count distinct, sum, avg, min, max |
Aggregation columns require a Group by to be meaningful.
3. Filters
Filter rows before they reach the table. Conditions depend on the field type:
| Field type | Available operators |
|---|---|
| String | equals, contains, starts_with, is null |
| Number | =, >, <, >=, <=, between |
| Date | in range, last N days, this week, this month |
| Source | equals |
Multiple filters are combined with AND.
4. Group by
Group results by one or more fields. When grouping by date, choose the granularity: day, week, or month.
Example: group orderCompleted events by currency and week to get weekly revenue per currency.
5. Sort
Sort the result by any column, ascending or descending.
6. Time range
Restrict the query to a date range. Applied to the event timestamp.
Saved Views
After configuring a table you can save it as a named view:
- Click Save
- Enter a name
- The view appears in Tables in your project sidebar
Saved views can be reopened, modified, and re-saved at any time. Saving creates a new snapshot of the configuration — it doesn't affect previously saved versions unless you explicitly overwrite.
Export
Any table result can be exported to CSV via the Export → CSV button. The export includes all rows matching the current configuration (not just the visible page).
Example: weekly revenue by currency
| Setting | Value |
|---|---|
| Event filter | order_completed |
| Columns | week (group), currency (group), sum(value) |
| Filters | currency is not null |
| Group by | currency, week |
| Sort | week descending |
| Time range | Last 90 days |
Result: a table showing total revenue broken down by currency for each week.
Introduction
TrichiData is a SaaS analytics platform for developers. It gives your team a single place to collect events from any application and explore that data through a flexible table builder — no SQL required.
Destinations Overview
Destinations are external analytics services that receive a copy of your events via server-side forwarding.