---
metadata:
- name: generator
content: Diplodoc Platform v5.63.0
alternate:
- en/visualization-ref/indicator-chart
- ru/visualization-ref/indicator-chart
- href: en/visualization-ref/indicator-chart.md
type: text/markdown
title: Markdown version
csp:
- script-src:
- https://mc.yandex.ru
img-src:
- https://mc.yandex.ru
connect-src:
- https://mc.yandex.ru
- wss://mc.yandex.ru
child-src:
- 'blob:'
- https://mc.yandex.ru
frame-src:
- 'blob:'
- https://mc.yandex.ru
frame-ancestors:
- 'blob:'
- https://mc.yandex.ru
canonical: en/visualization-ref/indicator-chart.html
title: Indicator in DataLens On-premises
description: >-
In this tutorial, you will learn how to create and customize the indicator
visualization type in DataLens On-premises.
vcsPath: en/visualization-ref/indicator-chart.md
---
# Indicator in DataLens On-premises
An indicator reflects the value of a single key measure. To build a more [complex](#markup-indicator) and meaningful indicator, use several measures.
* You may want to use indicators when a dashboard contains values you need to monitor on a regular basis to understand the general picture. This could be, for example, the number of incidents for the previous day, plan performance percentage, or year-on-year sales growth.
* Indicators are most commonly placed at the top or on the right side of a dashboard. Add no more than six indicators per screen so they remain in focus without confusing the user. Adjust widget sizes to reflect the importance of different metrics.
* You can set up the size and color of an indicator.
{% list tabs %}
- Visualization
- Source table
Year | Sales|
-----|---------|
2022| 6M |
2021| 28M |
2020| 18M |
2019| 9M |
2018| 1M |
{% endlist %}
## Wizard sections {#wizard-sections}
Wizard section| Description
----- | ----
Measure | Measure. One measure that determines the indicator value.
Colors | The field from the **Measure** section is used. The setting in this section allows [changing the color](#color-setting) of the indicator.
Filters | Dimension or measure. Used as a filter.
## Creating an indicator {#create-diagram}
To create an indicator:
{% note warning %}
If you use the new DataLens object model with [workbooks and collections](../workbooks-collections/index.md):
1. Go to the DataLens home page.
1. Open the workbook, click **Create** in the top-right corner, and select the object you need.
Follow the guide from step 4.
{% endnote %}
1.
Go to the DataLens home page.
1.
In the left-hand panel, select **Charts**.
1.
Click **Create chart** → **Chart**.
1.
At the top left, click **Select dataset** and specify the dataset to visualize. If you do not have a dataset, [create one](../dataset/create-dataset.md#create).
1. Select the **Indicator** chart type.
1. Drag a dimension or measure from the dataset to the **Measure** section. The value is displayed as a number.
## Additional settings {#additional-settings}
### Customizing header display {#indicator-title}
To customize header display:
1. At the top of the screen, click next to the chart type.
1. Select header display options:
* `Field name`: Show field name in header.
* `Manually`: Rename header.
* `Hide`: Hide header.
1. Click **Apply**.
{% cut "Chart settings window" %}
{% endcut %}
### Changing indicator size {#size-setting}
This setting is not available for a field of the `Markup` type. In this case, use [markup functions](../function-ref/markup-functions.md) for formatting as when [creating a complex indicator](#markup-indicator).
To change the indicator size:
1. At the top of the screen, click next to the chart type.
1. Select one of the size presets and click **Apply**.
### Changing indicator color {#color-setting}
This setting is not available for a field of the `Markup` type. In this case, use [markup functions](../function-ref/markup-functions.md) for formatting as when [creating a complex indicator](#markup-indicator).
To change the indicator color:
1. Under **Colors**, click .
1. Select a color pallete and color, then click **Apply**.
### Creating a complex indicator {#markup-indicator}
To create a complex indicator representing a number of measures, use the [markup functions](../function-ref/markup-functions.md). Proceed as follows:
1. Create a [calculated field](../concepts/calculations/index.md) using the markup functions.
1. Drag a field from **Measures** to the indicator's **Measure** section.
{% cut "Text formatting" %}
```markdown
BOLD(SIZE('Payment by card: ', '18px')) +
BR() + BR() +
SIZE(COLOR(STR(COUNTD_IF([OrderID], [PaymentType]='Bank card')),'blue') + ' / ' + STR(COUNTD([OrderID])), '26px') +
BR() + BR() +
SIZE(STR(ROUND(COUNTD_IF([OrderID], [PaymentType]='Bank card')/COUNTD([OrderID])*100, 2)) +
' % in total', '20px')
```
{% endcut %}
{% cut "Indicator with multiple measures" %}
```markdown
SIZE('Amount: ', '18px') +
BR() + BR() +
COLOR(SIZE('- categories: ' + STR(COUNTD([ProductCategory])), '18px'), '#BE2443') +
BR() +
COLOR(SIZE('- subcategories: ' + STR(COUNTD([ProductSubcategory])), '18px'), 'blue') +
BR() +
COLOR(SIZE('- brands: ' + STR(COUNTD([ProductBrend])), '18px'), 'green') +
BR() +
COLOR(SIZE('- products: ' + STR(COUNTD([ProductName])), '18px'), '#FF7E00')
```
{% endcut %}
{% cut "Indicator with a measure by category" %}
```markdown
SIZE('Sales: ' + COLOR(STR([Sales])+ ' ₽', 'green'), '26px') +
BR() +
COLOR(" ▲ ", "green")+": More than ₽50,000,000 | " + COLOR(" ▼ ", "red") + ": ₽50,000,000 or less" +
BR() + BR() +
SIZE(
COLOR('| ' + STR(SUM_IF([Sales],[ProductCategory]='Home appliances'))+ ' ₽ | ', 'blue') +
COLOR(if(SUM_IF([Sales],[ProductCategory]='Home appliances')>50,000,000, " ▲ "," ▼ "), if(SUM_IF([Sales],[ProductCategory]='Home appliances')>50,000,000,"green", "red")),
'20px') +
BR() + 'Home appliances' +
BR() + BR() +
SIZE(
COLOR('| ' + STR(SUM_IF([Sales],[ProductCategory]='Household chemicals'))+ ' ₽ | ', 'green') +
COLOR(if(SUM_IF([Sales],[ProductCategory]='Household chemicals')>50,000,000, " ▲ "," ▼ "), if(SUM_IF([Sales],[ProductCategory]='Household chemicals')>50,000,000,"green", "red")),
'20px') +
BR() + 'Household chemicals' +
BR() + BR() +
SIZE(
COLOR('| ' + STR(SUM_IF([Sales],[ProductCategory]='Household products'))+ ' ₽ | ', 'violet') +
COLOR(if(SUM_IF([Sales],[ProductCategory]='Household products')>50,000,000, " ▲ "," ▼ "), if(SUM_IF([Sales],[ProductCategory]='Household products')>50,000,000,"green", "red")),
'20px') +
BR() + 'Household products'
```
{% endcut %}
{% cut "Indicator with an image" %}
```markdown
IMAGE('https://storage.yandexcloud.net/dl--********//datalens.jpg', 32, 32, 'alt-text-1') +
COLOR(SIZE('| ' + STR(SUM_IF([Usage],[Service]='DataLens')), '32px'), '#AEC5F3') +
BR()+
COLOR(SIZE('DataLens', '20px'), '#AEC5F3')+
BR()+
BR()+
IMAGE('https://storage.yandexcloud.net/dl--********//powerbi.jpg', 32, 32, 'alt-text-1') +
" " + COLOR(SIZE('| ' + STR(SUM_IF([Usage],[Service]='Power BI')), '32px'), '#B8A754')+
BR()+
COLOR(SIZE('Power BI', '20px'), '#B8A754')+
BR()+
BR()+
IMAGE('https://storage.yandexcloud.net/dl-********/tableu.jpg', 32, 32, 'alt-text-1') +
" " + COLOR(SIZE('| ' + STR(SUM_IF([Usage],[Service]='Tableau')), '32px'), '#4D5DAB')+
BR()+
COLOR(SIZE('Tableau', '20px'), '#4D5DAB')
```
{% endcut %}
## Recommendations {#recommendations}
* Use emojis when calculating indicator values to make them more informative.
This indicator chart uses a calculated field with the following formula: `IF([Average spend]>2200, CONCAT("✔️",STR(ROUND([Average spend]))),CONCAT("🔻",STR(round([Average spend]))))`.
* Describe the context to make it clear what indicators mean.
#### Useful links {#see-also}
* [Creating a dashboard in DataLens On-premises](../operations/dashboard/create.md)
* [Adding a chart to a dashboard in DataLens On-premises](../operations/dashboard/add-chart.md)
* [Adding a selector to a dashboard in DataLens On-premises](../operations/dashboard/add-selector.md)