> For the complete documentation index, see [llms.txt](https://docs.powertable.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.powertable.com/explore-powertable/working-with-powertable/explore-data/column-insights.md).

# Column Insights

The Insights option displays an overview of column values, allowing you to quickly extract key information and insights from column measures and make informed decisions.

Assume you are working with a large dataset and need to review any column to determine the number of missing or unique entries or perform a simple categorization analysis. You may want to find the earliest and latest dates in your data, or you may need to calculate the column data's range, average, median, or standard deviation.

The Insights option allows you to perform all of these tasks more efficiently while gathering useful insights. 

<figure><img src="/files/CSSYcP9WFL6TvrGoOe4T" alt=""><figcaption><p>Insights</p></figcaption></figure>

Here are some details you can get:

* Sum
* Average
* Median
* Minimum value, maximum value and range
* Standard deviation
* Number of empty entries/percentage of empty entries
* Number of filled-in entries/percentage of filled-in entries
* Number of unique entries/percentage of unique entries
* Earliest and the most recent date in a date column
* Date range in days or months

In the example below, we have applied the 'Insights' option to a few columns.

<figure><img src="/files/At1UaXRCPBo72b0xZefM" alt=""><figcaption></figcaption></figure>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.powertable.com/explore-powertable/working-with-powertable/explore-data/column-insights.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.