Skip to main content
Get Started
Documentation

Searchable and transposed tables in Tractorscope

Searchable and transposed table options help adapt table charts to the way viewers need to inspect data.

Searchable tables

Searchable tables are useful when a table contains many rows and viewers need to find a specific customer, order, account, or record.

Transposed tables

Transposed tables flip the orientation so fields can be read vertically. This is useful for single-record summaries, profile views, or tables with many columns and few rows.

SQL shape

Searchable tables work well with ordinary row-based SQL results. Transposed tables work best with focused result sets:
select
  customer_name,
  plan,
  mrr,
  created_at,
  account_owner
from accounts
where id = :account_id
select
  customer_name,
  plan,
  mrr,
  created_at,
  account_owner
from accounts
where id = :account_id

Tips

  • Use searchable tables for large row sets.
  • Use transposed tables for one record or compact summaries.
  • Keep column names human-readable with SQL aliases.

Related docs