• English

      • Analysis Tools

      Pivot table

      Build pivots from row dimensions, column dimensions, and measures (count / sum / avg / min / max), with:

      • High-cardinality warnings — get a heads-up before expanding an enormous set of categories.
      • Open as a tab — from the pivot dialog, choose Open in tab to keep the configuration in a dedicated workspace tab (pivot type). You can change dimensions and measures there and Run again. The tab remembers the source snapshot and config (not the result grid); after restart, click Run to refresh. Right-click the tab to Copy pivot SQL or Go to source.
      • Copy-SQL support — export the pivot definition as SQL for reuse or inspection.
      • Show as — after running, switch the result grid to values, % of row, or % of column (frontend-only; does not change the SQL). Each measure is normalized independently. If the query hits the 5000 group cap, percentages are relative to the returned groups only.
      • Column header sort — click a column dimension header (or corner title) or measure column header to sort (asc / desc / clear). Sorting uses the currently displayed values (including percent mode) and does not re-query. Column dimensions default to stable ascending order.
      • Resizable dialog — drag any edge or corner to resize the pivot dialog. The size resets when the app restarts.

      Column profile

      Open Column profile from the column header menu in table browse and query results. One dialog shows summary statistics and the value distribution:

      • Summary — total, null ratio, distinct count, and min / max. Distinct count is COUNT(DISTINCT) and is not limited by the distribution cap.
      • Distribution — distinct value, row count, and percent of all matching rows (two decimal places, e.g. 12.35%), as a table plus a bar chart.
      • Denominator — percent uses the profile query’s total for the same row set as the parent view (table browse or query result), including the current WHERE.
      • Cap — the table lists the top 1000 distinct values by count. When capped, a note explains that percent is still relative to all matching rows, so the shown groups may sum to less than 100%. When not capped, group percents should add up to about 100%.
      • Chart — the bar chart plots count (not percent) for the first 30 groups.
      • Context menu — right-click the result table to Copy or Copy as CSV. On the value column, Filter by this value adds that raw value to the parent SQL (column = value, or IS NULL) and refreshes. Table browse appends the predicate to WHERE. Query results keep the original statement and re-run it inside a filtered subquery.
      • Resizable dialog — drag any edge or corner to resize the profile dialog. The size resets when the app restarts.

      Value viewer

      Inspect a cell in raw / JSON form, with a Calculate tab for per-selection statistics (min / max / mean / …) exported as Markdown.