# 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: 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:

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

The question should be specific, self-contained, and written in natural language.
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.