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

# Limit Values

The Limit Values feature literally limits/filters output of the categorical values by the conditions.

Limit Values is supported in the following chart types.

* Pivot (Row, Column)
* Summarize Table (Group By)
* Bar (X-Axis, Color, Repeat By)
* Line  (Color, Repeat By)
* Area (Color, Repeat By)
* Scatter (With Aggregation) (X-Axis, Y-Axis, Color, Repeat By, Group By)
* Boxplot (X-Axis, Color, Repeat By)
* Violin (X-Axis, Color, Repeat By)
* Histogram (Color, Repeat By)
* Density Plot (Color, Repeat By)
* Error Bar (X-Axis, Color, Repeat By)
* Map - Extension (Color)

## Overview

Suppose you have a Bar chart with a lot of bars. You may want to reduce the number of bars because there are too many bars and hard to compare.

![](https://mintcdn.com/exploratory-inc/AyunTLp0xRbqd_Wj/en/viz/images/limit1.png?fit=max\&auto=format\&n=AyunTLp0xRbqd_Wj\&q=85\&s=b0c5ccbf0c436f50abb8a3c31f2e3eb4)

You can definitely create a filter to reduce bars. But, it is not straightforward to define a filter based on the aggregated values (in this case, the size of bars) such as "Showing top 20 bars". Limit Values provides a set of ways to filter categories based on the aggregated values by category. For example, you can get the top 20 of bars by just setting "Top" with "20" results.

![](https://mintcdn.com/exploratory-inc/AyunTLp0xRbqd_Wj/en/viz/images/limit3.png?fit=max\&auto=format\&n=AyunTLp0xRbqd_Wj\&q=85\&s=5e40666b169e2e36bfebb4557162df62)

You can access Limit Value setting from the column menu.

![](https://mintcdn.com/exploratory-inc/AyunTLp0xRbqd_Wj/en/viz/images/limit2.png?fit=max\&auto=format\&n=AyunTLp0xRbqd_Wj\&q=85\&s=9cc16f0d68e3866d57e46cc2e8bda9c8)

## Types

There are 3 Limit Value types.

### Condition

You can define a condition against the aggregated values of each category to filter. For example, you can define "Countires that have sales amount more than 500,000.".

![](https://mintcdn.com/exploratory-inc/AyunTLp0xRbqd_Wj/en/viz/images/limit5.png?fit=max\&auto=format\&n=AyunTLp0xRbqd_Wj\&q=85\&s=fdd5287bbccb58020e87443509f253f5)

Following options are available.

* Based on: Values to compare. You can select a column that has values to compare and aggregation function. By default, it uses the same value column and its aggregation function used in the chart. You can also choose a different column and different aggregation function that is not even used in the chart.
* Set Position: See [below](#set-position) for detail.
* Operator: The Operator of the condition. Following operators are available.
  * equal to
  * not equal to
  * less than
  * less than or equal to
  * greater than
  * greater than or equal to
  * between
  * not between
* Value: Condition value

### Top

You can show only the number of categories that have the highest values. For example, you can set 20 to show top 20 countries.

![](https://mintcdn.com/exploratory-inc/AyunTLp0xRbqd_Wj/en/viz/images/limit3.png?fit=max\&auto=format\&n=AyunTLp0xRbqd_Wj\&q=85\&s=5e40666b169e2e36bfebb4557162df62)

Following options are available.

* Number of Results: Number of categories to show.
* Based on: Values to compare. You can select a column that has values to compare and aggregation function. By default, it uses the same value column and its aggregation function used in the chart. You can also choose a different column and different aggregation function that is not even used in the chart.

### Bottom

You can show only the number of categories that have the lowest values. For example, you can set 20 to show bottom 20 countries.

![](https://mintcdn.com/exploratory-inc/AyunTLp0xRbqd_Wj/en/viz/images/limit4.png?fit=max\&auto=format\&n=AyunTLp0xRbqd_Wj\&q=85\&s=6d9297f48cb6068e18845a38e7382793)

Following options are available.

* Number of Results: Number of categories to show.
* Based on: Values to compare. You can select a column that has values to compare and aggregation function. By default, it uses the same value column and its aggregation function used in the chart. You can also choose a different column and different aggregation function that is not even used in the chart.

## Set Position

In the Limit setting for Color, you can set the position to compare and limit values. For example, if you have a Line chart showing Sales median values of each region and you want to show the top 5 region based on the last values.

![](https://mintcdn.com/exploratory-inc/AyunTLp0xRbqd_Wj/en/viz/images/limit9.png?fit=max\&auto=format\&n=AyunTLp0xRbqd_Wj\&q=85\&s=981bc7792f2c1f71ddf0419c51802a38)

You can do it by checking the "Set Position" checkbox, selecting "Last Value".

![](https://mintcdn.com/exploratory-inc/AyunTLp0xRbqd_Wj/en/viz/images/limit8.png?fit=max\&auto=format\&n=AyunTLp0xRbqd_Wj\&q=85\&s=d21d79bf9f0160806af073ee5d59f9ac)

You can also pick the top 5 region based on the first values.

![](https://mintcdn.com/exploratory-inc/AyunTLp0xRbqd_Wj/en/viz/images/limit6.png?fit=max\&auto=format\&n=AyunTLp0xRbqd_Wj\&q=85\&s=ddb28cf044a68d4b1245a79fd6c25222)

You can select by selecting "First Value".

![](https://mintcdn.com/exploratory-inc/AyunTLp0xRbqd_Wj/en/viz/images/limit7.png?fit=max\&auto=format\&n=AyunTLp0xRbqd_Wj\&q=85\&s=b29c8d87e323f21783032fc71d169bf2)

The following positions are available.

* First Value
* Last Value


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.