Viewing your data

Open an experiment and select Data. The dataset picker above the table names the dataset you are looking at and its row count. Opening it lists every dataset in the experiment, grouped by where it came from: the source tables, anything a macro produced, and anything uploaded.

Inspect a table

• Open the dataset picker to change tables. Type to filter it when an experiment holds many datasets.
• Select a column heading to sort ascending or descending.
• Use filter chips to narrow rows by one or more columns.
• Change the rows per page or move through pages.
• Expand structured values when a cell cannot be read comfortably inline.
• Select rows to add or remove comments and quality annotations.

Numeric columns can open a quick table chart. This is useful for checking a distribution while cleaning data; it is not a saved analysis.

A table with more than 200,000 rows opens on its latest 30 days: the filter bar shows a timestamp filter starting 30 days before the newest measurement. It is an ordinary filter, so change the date or remove it to see older rows.

A field from a macro, a question, custom metadata or an uploaded file can have the same name as a column the table already has, such as device or id. The table keeps both. The table's own column keeps the plain name, and the field appears beside it under its own name with a small tag saying where it came from. Hover the tag to see why. Filters and chart pickers show the same tag.

New rows arrive on their own

You do not need to reload the page to see new measurements. While the browser tab is visible, the Data page checks for new rows every 30 seconds and refreshes the table when the dataset in front of you changes. After ten minutes without mouse, keyboard or scroll input it stops checking and the line says Paused; the next input catches up at once. A row that arrives this way is tinted for a moment so you can spot it. Your sort, filters, page and selected rows stay where they were.

The line under the page description says Live and when the newest data in the dataset was received. For a macro dataset, that is when the measurement the result came from was received, not when the macro ran. Select the pause button beside it to hold the table still while you work through it, and select it again to catch up. If the page cannot reach the platform for two minutes, the line says when it last refreshed instead. Dashboards and the visualization editor show the same line, for the datasets their charts and tables use.

Build a saved visualization

Open the experiment's Analysis area and choose Visualizations. Anyone with Can edit can create a visualization, select a data table and columns, choose a chart type, and configure its style. Saved visualizations can also be placed on experiment dashboards.

The current interface supports many chart families, but a chart is only as sound as its data configuration. Check units, missing values, grouping, contributor anonymization, and the protocol version before interpreting a pattern.

A line or area chart over time or a number draws a long series at screen resolution: for every pixel column it keeps the first, last, lowest and highest value, so a peak or a gap never disappears from view. Zooming in redraws the visible range in more detail, down to single rows. When a series is longer than one read, the chart draws the whole table this way instead of its first rows. A line under the chart says when it is drawn at screen resolution, and Show every point draws every row the chart read instead. A line styled with markers draws them only while its visible range holds at most 2,000 points, so a long series shows as a clean line. The markers return as you zoom in, or everywhere with Show every point.

Other charts, and stacked, faceted or aggregated ones, read at most 100,000 rows, and tables with very wide rows can stop them sooner. When the data holds more, a line under the chart says how much it shows, for example Showing 100,000 of 553,000 rows. Add a filter to the visualization or to the dashboard until every matching row fits, or export the table to work with all of it.

For R, Python, or another statistics tool, continue with Exporting data.