# Mini chart

The action will show a minichart based on a measure value.

{% hint style="info" %}
This action can be applied on a cell with a measure
{% endhint %}

There are following minichart options available:

* Histogram
* Histrogram (2 Levels)
* Bullet

### Histogram

![](/files/-LdEBWS7McEKbgJ_47uo)

Histogram is the graphical way of representing KPIs.

![](/files/-LdEIqn_AlfRTIOzJfWS)

It is possible to set the minimum, average and maximum values and set the corresponding colors. By default, those parameters are initialized based on the corresponding measure values.

The "**Offset**" parameter is optional and can be used to apply offset on a bar based on the selected measure. To open list of available measures and be able to select a measure, click <img src="/files/-LdEDmHUK1NHtJlTLT0b" alt="" data-size="original"> button.

![](/files/-LdEHlme4-lTqsvmsEGC)

The "**Offset**" parameter can be used to build **WaterFall** charts.

![](/files/-LdEILwBXo1ODVE0Tf1J)

**To create WaterFall** chart you should add a measure which will define the offset for each dimension's value. In our example we have used a dimension with the following values: "In stock", "In transit", "Damaged", etc. Stocks level is determined by the measure "StocksLevel" which was defined as: `SUM(StockLevel)`. The Offset measure called "BarOffset" can be defined in the following way: `rangesum(above("StocksLevel"), above("BarOffset"))`. So, Minichart action is applied on the "StocksLevel" measure with selected "BarOffset" measure as the "Offset" parameter.&#x20;

See Demo Apps page for more details.

{% content-ref url="/pages/-LdELleT1sT6986TeNLa" %}
[Demo Apps](/demo-apps.md)
{% endcontent-ref %}

It is also possible to change the size of the minichart using the “**Width**” and “**Height**” options. The width and height is set in percentage of the occupied area.

There is the "**Hide**" parameter under the "Value labels" header.  It allows to hide value labels.

### Histogram (2 Levels)

![](/files/-LbX6cr3OuCRpW1ti1T7)

It allows to show a histogram with two color levels only.

A Boundary value is set to the average of the corresponding measure by default and can be changed.

It is also possible to change the size of the minichart using the “Width” and “Height” options.

### Bullet

![](/files/-LbX7peqJhiJ-vYBRAS5)

It allows to show the bullet chart, based on a measure value. The additional measure can be used to draw the reference line.

The "Measure" parameter is bonded to the measure of the current cell and, thus, it can't be changed here.

It is possible to change color, font size, font color and label position for the "Measure" parameter.

The "Reference line expression" is not mandatory but can be used to show the reference line using the specified measure. It is also possible to set the appropriate color for the reference line, and additionally - font size, color and label position.

Background color can be also changed.


---

# 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://help.rbcgrp.com/actions/mini-chart.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.
