# 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://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2Fsync%2Ff6d1e5916fa3584b8dc67ccf6b42d97abb1b1128.png?generation=1590864965520359\&alt=media)

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.

![](broken-reference)

You can access Limit Value setting from the column menu.

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2Fsync%2F69552d81190a2535e5f59918f0f52d5c52fc6c0e.png?generation=1590864958624053\&alt=media)

## 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://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2Fsync%2F9c8abdf3d61d7102c52686d447fa628e6e7b102f.png?generation=1590864973737291\&alt=media)

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.

![](broken-reference)

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://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2Fsync%2F9c03133284b3323a528f899cdfd7cc352c4e2651.png?generation=1590864963530830\&alt=media)

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://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2Fsync%2F311dbc174d8c84404963e3d9946e616d6e0570b7.png?generation=1590864971516628\&alt=media)

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

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2Fsync%2F902fa710c87516afbdb52a22e1a1d66be69ededf.png?generation=1590864972526528\&alt=media)

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

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2Fsync%2F5c5405079bba1045c424c51827ab3f840e45ec7a.png?generation=1590864973712339\&alt=media)

You can select by selecting "First Value".

![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2Fsync%2Faecc72d3170719e512fe0c841916bbfd4e96ffe6.png?generation=1590864960454548\&alt=media)

The following positions are available.

* First Value
* Last Value