> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dataerai.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Visualize your data

> Explore a ready dataset with built-in charts — histograms for numeric columns and category charts for labels — without leaving Dataerai.

Once a tabular [dataset version](/datasets/overview) is **Ready**, you can chart its columns directly in Dataerai — no export, no separate tool.

## Choose a chart

Open an asset and the sidebar's **General** tab shows a preview chart. A **Visualization** dropdown lists every chart that fits the data — only the kinds Dataerai can build from the current columns appear, so you never pick one that would come up empty:

* **Histogram** — the distribution of a single column's values.
* **Table** — a row-level preview of the data.
* **Scatter** — one numeric column against another.
* **Time series** — values traced in order, for sequential or time-based data.
* **Distribution** — box, violin, or bar charts grouped by a category.
* **Heatmap** — a matrix or density grid across two columns.

Pick the chart you want from the dropdown. If you can edit the asset, choose **Set as default** to remember that choice for everyone who opens the asset later.

For a tabular asset, Dataerai prepares the chart automatically: select the asset and a preview appears once its dataset version is ready.

## Delete an asset with generated visualization data

When Dataerai prepares charts for a tabular asset, it may create an auto-promoted dataset version for that visualization. If you delete the asset later, the confirmation dialog includes **Also delete auto-promoted visualization dataset versions?**. The option is selected by default so the generated visualization data is removed with the asset.

Clear the option if you want to stop and review linked dataset versions before deleting the asset. Dataset versions that were not auto-promoted for visualization still protect their source asset and must be removed separately.

## Pick a column, get a chart

Select a column and Dataerai chooses the right chart for its type:

* **Numeric and date/time columns** render as a **histogram** — the distribution of values across bins.
* **Categorical and text columns** render as a **bar chart of category counts** — the most common values.

<Frame caption="A numeric column renders as a histogram of its distribution — pick the column from the selector at the top of the chart.">
  <img src="https://mintcdn.com/dataerai/JYQfiA1164D5XDuO/images/visualize.png?fit=max&auto=format&n=JYQfiA1164D5XDuO&q=85&s=b672f9ab03628c946993e26884827fb0" alt="Dataerai histogram chart for a numeric dataset column with a column selector" width="320" height="225" data-path="images/visualize.png" />
</Frame>

<Frame caption="Selecting a categorical column switches the chart to a bar chart of category counts.">
  <img src="https://mintcdn.com/dataerai/JYQfiA1164D5XDuO/images/visualize-category.png?fit=max&auto=format&n=JYQfiA1164D5XDuO&q=85&s=0d05b6b6412172b99fb7c2e5d410b54a" alt="Dataerai bar chart of category counts for a categorical dataset column" width="320" height="225" data-path="images/visualize-category.png" />
</Frame>

## Relate two columns

Beyond single-column distributions, Dataerai charts relationships between columns — a **scatter** plots one numeric column against another, so you can spot correlations and outliers at a glance. Add an optional **color** column to shade the points — by category for a label column, or along a gradient for a numeric one — so a third dimension reads at a glance.

<Frame caption="A scatter chart relates two numeric columns to reveal correlation and outliers.">
  <img src="https://mintcdn.com/dataerai/JYQfiA1164D5XDuO/images/visualize-scatter.png?fit=max&auto=format&n=JYQfiA1164D5XDuO&q=85&s=1875771f9bb90543d266e821dd2b66b3" alt="Dataerai scatter chart relating two numeric dataset columns" width="320" height="215" data-path="images/visualize-scatter.png" />
</Frame>

A **time series** chart traces values in order — useful for time-based and sequential measurements. Choose an **aggregation** (none, mean, sum, median, or count) to collapse repeated x values into a single point per step.

<Frame caption="A time series chart traces a column's values in sequence.">
  <img src="https://mintcdn.com/dataerai/JYQfiA1164D5XDuO/images/visualize-line.png?fit=max&auto=format&n=JYQfiA1164D5XDuO&q=85&s=77c653e47457d1535d156cf622f20cae" alt="Dataerai time series chart tracing dataset values in sequence" width="320" height="186" data-path="images/visualize-line.png" />
</Frame>

## Compare distributions across groups

When your data has a category to group by and a numeric value to summarize, a **distribution** chart compares groups side by side. Switch between three views:

* **Box** and **violin** plots show the spread of values within each group.
* **Bar** charts aggregate each group into a single number — choose **count**, **mean**, **median**, or **sum**.

## See a matrix or density grid

A **heatmap** renders a two-column grid:

* With two categorical columns, it builds a **pivot matrix** — one cell per pair of categories.
* With two numeric columns, it builds a **density grid** — useful for spotting where values cluster.

Optionally color the cells by an aggregate of a numeric **value** column (count, mean, median, or sum), and switch the **colour scale** to suit your data.

## Adjust the view

Open the full chart to tune it with a live parameter panel. The controls match the chart you're viewing:

* **Bin count** — how many bins a numeric histogram uses.
* **Top categories** — how many categories a category chart shows.
* **Max rows** — the amount of data scanned for the chart.
* **Group**, **value**, and **aggregation** — for distribution and heatmap charts, the columns to group by and summarize.
* **Colour scale** — the palette a heatmap uses.

Changes apply live as you adjust them.

<Frame caption="Open the full chart to reveal the Chart parameters panel — field, bin count, and max rows.">
  <img src="https://mintcdn.com/dataerai/JYQfiA1164D5XDuO/images/visualize-params.png?fit=max&auto=format&n=JYQfiA1164D5XDuO&q=85&s=12926971cdd0928be2c4e09e2f0e9fe4" alt="Dataerai expanded chart parameter panel with field, bin count, and max rows" width="320" height="205" data-path="images/visualize-params.png" />
</Frame>

<Note>
  Large datasets are automatically **sampled** so charts stay fast and responsive. When a chart is based on a sample, you're working with a representative subset rather than every row.
</Note>

## Preview the rows

Alongside the charts, you can preview the dataset's **rows** as a table to see the actual values behind a column — useful for sanity-checking before you read too much into a distribution.

<Frame caption="The expanded row preview — all rows, a Download CSV action, and per-column toggles.">
  <img src="https://mintcdn.com/dataerai/JYQfiA1164D5XDuO/images/dataset-table-full.png?fit=max&auto=format&n=JYQfiA1164D5XDuO&q=85&s=ceef0c7be7e188b78632834f945da3c0" alt="Dataerai expanded dataset row preview with all rows and Download CSV" width="1060" height="660" data-path="images/dataset-table-full.png" />
</Frame>

## Next steps

<CardGroup cols={2}>
  <Card title="Understand your data" icon="table-2" href="/datasets/understand-your-data">
    The schema and statistics behind the charts.
  </Card>

  <Card title="Search & discover" icon="search" href="/discover/search">
    Find the data you want to chart.
  </Card>
</CardGroup>
