Explore
Pivot, Worksheet, and Visualization on a fetched sample, with aggregates, calculations, export, and recipes.
Explore is a second window, not a sidebar route. It opens from Query Builder or SQL after a sample has been fetched. Pivot, Worksheet, and Visualization all work on those fetched rows. Aggregates run here.
The sample does not change
Changing the view does not query the database. If you run again in Builder or SQL, a banner offers Refresh sample from those latest results. That refresh does not query the server. It copies the new sample the other screen already fetched.
Modes
- Pivot: group rows, columns, values, and filters on the sample. Each row dimension is its own column. Names use the column, and qualify with the table when two names collide.
- Worksheet: a spreadsheet layout, with grouping and calculations on the same rows.
- Visualization: chart types Auto, Bar, Line, Scatter, Histogram, and KPI.
Click a mark or cell to open Source rows from the sample. Export rows writes those matching rows to CSV.
Aggregates and calculations
Pivot values are Count rows, Count numbers, Count distinct, Sum, Average, Minimum, Maximum, Product, Standard deviation, Population standard deviation, Variance, and Population variance. A value can also be shown as Value, % grand total, % row total, % column total, % parent, Difference, % difference, Running total, % running total, Rank ascending, or Rank descending.
Groups are Exact values, or a date bucket of Year, Quarter, Month, ISO week, or Day. Numbers can be binned.
Worksheet calculations have four kinds. Quick is a running total, running
average, percent of total, previous value, difference from previous, rank ascending, or rank
descending. Row and Group take a formula: numbers, parentheses, and + - * /. A name in square brackets, such as [Amount], refers to another value. Division by zero is an error. Summary is count, count distinct, sum, average, minimum, or maximum.
Export
Export HTML writes the exploration into a single self-contained file. Export CSV is also available. On Visualization, Export PNG and Export chart data are available as well.
Recipes
Saved recipes keep layout by default: no credentials, no result rows. Optionally Include Builder query, and applying the recipe can restore that spec and Confirm and run it on a selected connection (the same limits and risk gate as
any other run). Import and export use .safedb-recipe.json.
Row limits and confirmation still live on Limits & risk model; the builder that produced the sample is Query builder.