---
metadata:
- name: generator
content: Diplodoc Platform v5.47.3
alternate:
- https://yandex.com.tr/support/tracker/en/tutorials/visualisation-in-datalens.md
title: Visualizing data from Tracker
description: To visualize data from Tracker, set up regular export of data to external storage and visualize the required metrics and data using DataLens tools.
---
> **Documentation Index:** Fetch the complete configuration index at https://yandex.com.tr/support/tracker/en/llms.txt
# Visualizing data from Yandex Tracker
Visualizing data from Tracker to DataLens allows you to build more advanced analytics than when using the Tracker tools.
To visualize data from Tracker to DataLens:
* Set up regular export of data to external storage.
* Visualize the required metrics and data using DataLens.
To visualize the data, follow these steps:
1. [Prepare your cloud](#before-you-begin).
1. [Create a DB for storing the Tracker data](#database-create).
1. [Create an OAuth token for Tracker access](#oauth-token).
1. [Create a Cloud Functions function for importing the data](#function-import).
1. [Create a connection to DataLens](#connection-create).
1. [Create a dataset](#dataset-create).
1. [Create a chart](#chart-create).
1. [Create a dashboard in DataLens and add charts to it](#dashboard-create).
## Getting started {#before-you-begin}
{% note info "" %}
To obtain data, [log in to Tracker](https://yandex.com.tr/support/tracker/en/user/login.md) under the account of a user with full access to the service.
{% endnote %}
Sign up for Yandex Cloud and create a billing account:
1. Go to the [management console](https://console.cloud.yandex.com) and log in to Yandex Cloud or create an account if you do not have one yet.
1. On the **[Billing](https://billing.cloud.yandex.com/)** page, make sure you have a [billing account](https://yandex.cloud/en/docs/billing/concepts/billing-account) activated and its status is `ACTIVE` or `TRIAL_ACTIVE`. If you do not have a billing account, [create one](https://yandex.cloud/en/docs/billing/quickstart).
If you have an active billing account, you can create or select a folder on the [cloud page](https://console.yandex.cloud/cloud) to host your infrastructure.
[Learn more about clouds and folders](https://yandex.cloud/en/docs/resource-manager/concepts/resources-hierarchy).
### Required paid resources {#paid-resources}
* A paid [service plan](https://yandex.com.tr/support/tracker/en/enable-tracker.md) that grants full access to Tracker.
* A continuously running Managed Service for ClickHouse® cluster (see [Managed Service for ClickHouse® pricing](https://yandex.cloud/en/docs/managed-clickhouse/pricing.md)).
* Cloud Functions function usage (see [Cloud Functions pricing](https://yandex.cloud/en/docs/functions/pricing)).
If you no longer need the resources you created, [delete them](#clear-out).
## Create a DB for storing the Tracker data {#database-create}
1. Go to the [management console](https://console.cloud.yandex.com).
1. In the top-left corner, click **All services**.
1. Select **Data platform** → **Managed Service for ClickHouse**.
1. Click **Create ClickHouse cluster**.
1. Specify the cluster parameters:
* Basic parameters:
* **Environment**: `PRODUCTION`.
* **Version**: `24.8 LTS`.
* Resources:
* **Platform**: `Intel Ice Lake`.
* **Type**: `Standard`.
* **Host class**: `s3-c2-m8 (2 vCPU, 8 GB)`.
* Storage size: `30 GB`.
* Hosts:
* **Public access**: `Enabled`.
* DBMS settings:
* **User management via SQL**: `Disabled`.
* **Database management via SQL**: `Disabled`.
* **Username**: `tracker_data`.
* **DB name**: `db1`.
* Service settings:
* **DataLens access**: `Enabled`.
* **Access from Serverless**: `Enabled`.
For a full list of settings, see [Managed Service for ClickHouse® settings](https://yandex.cloud/en/docs/managed-clickhouse/concepts/settings-list).
1. Click **Create cluster**. Wait for the created cluster status to change to `Alive`.
1. Copy and save the host name for further Cloud Functions setup.
## Create an OAuth token for Tracker access {#oauth-token}
{% note warning "" %}
If you use a federated or service account, authenticate using an [IAM token](#iam-token).
{% endnote %}
To get a token:
1. Go to [https://oauth.yandex.com/](https://oauth.yandex.com/).
1. On the **Your applications** page, click **Create**.
1. In the window that opens, select the **For API access or debugging** option and click **Proceed to creation**.
1. Specify the application name and contact email.
1. Add permissions to access user data. To select a permission, start typing its name in the **Access name** field:
* **Write to tracker (tracker:write)** — all data operations: create, delete, edit.
* **Read from tracker (tracker:read)** — read-only access to data.
1. Click **Create application**.
1. In the [Yandex OAuth](https://oauth.yandex.com/) personal account, select the previously created application and copy its ID from the **ClientID** field.
1. Generate the token request link:
```
https://oauth.yandex.com/authorize?response_type=token&client_id=
```
1. Log in to the account on whose behalf you will work with the API and go to the generated link.
A sequence of characters will appear on the page — this is the OAuth token. Copy it and save it.
To check if you have access to the API, execute the [request for information about the current user](https://yandex.com.tr/support/tracker/en/api-ref/users/get-user-info.md). If access was not obtained, the request will return a response with code `401 Unauthorized`.
Example request for information about the current user using curl:
{% list tabs %}
- Unix
```bash
curl -X GET 'https://api.tracker.yandex.net/v3/myself' \
-H 'Authorization: OAuth y0__xAbc******' \
-H 'X-Org-ID: 1234******'
```
- Windows
```bash
curl -X GET "https://api.tracker.yandex.net/v3/myself" ^
-H "Authorization: OAuth y0__xAbc******" ^
-H "X-Org-ID: 1234******"
```
{% endlist %}
## Create a Cloud Functions function for importing the data {#function-import}
1. Go to the [management console](https://console.cloud.yandex.com).
1. In the top-left corner, click **All services**.
1. Select **Serverless computing** → **Cloud Functions**.
1. Click **Create function**.
1. Specify a name for the function and click **Create**.
1. In the **Editor** window that opens, select `Python / 3.9` runtime environment.
1. Click **Next**.
1. In the **Method** field, click **ZIP archive**.
1. Attach a [test archive](https://github.com/yandex-cloud-examples/yc-tracker-data-import/blob/main/build/tracker-data-import.zip).
1. In the **Entry point** field, specify `tracker_import.handler`.
1. Under **Parameters**, specify:
* **Timeout, sec**: `60`.
* **RAM**: `1024`.
* **Environment variables**:
* `TRACKER_ORG_ID`: Yandex 360 for Business organization ID
To get the organization ID, go to **Administration** → [**Organizations**](https://tracker.yandex.com/admin/orgs) and copy the value from the **ID** field. {#find-id}
* `TRACKER_OAUTH_TOKEN`: [OAuth token](#oauth-token) of the Tracker account
* `CH_HOST`: [Host](#database-create) name
* `CH_DB`: [Database](#database-create) name
* `CH_USER`: [Username](#database-create)
* `CH_PASSWORD`: [Password](#database-create)
* `CH_ISSUES_TABLE`: `tracker_issues`
* `CH_CHANGELOG_TABLE`: `tracker_changelog`
* `TRACKER_INITIAL_HISTORY_DEPTH`: `1d`
* `CH_STATUSES_VIEW`: `v_tracker_statuses`
1. Click **Save changes**.
1. In the **Testing** tab, click **Run test**.
1. The test result is a data import log:
```json
{
"statusCode": 200,
"headers": {
"Content-Type": "text/plain"
},
"isBase64Encoded": false,
"body": "OK"
}
```
1. Create a [trigger](https://yandex.cloud/en/docs/functions/concepts/trigger) for regular exports of new data to the database:
1. Go to the **Cloud Functions** section.
1. Click → **Create trigger**.
1. Set the trigger type to **Timer**.
1. In the **Cron expression** field, select `Every day`.
1. Under **Function settings**, click **Create new**.
1. Enter the account name. By default, the account is assigned the `functions.functionInvoker` role to use the trigger.
1. Click **Create**.
1. Click **Create trigger**.
## Create a connection in DataLens {#connection-create}
1. Open your [Managed Service for ClickHouse®](#database-create) **cluster**.
1. On the left side of the window, select **DataLens**.
1. Click **Create connection**.
1. Specify the connection settings:
* **Connection**: `Select in a folder`.
* **Cluster**: Cluster specified when [creating a database](#database-create).
* **Hostname**: Host specified when [creating a database](#database-create).
* **HTTP interface port**: `8443`.
* **Username**: Username specified when [creating a database](#database-create).
* **Password**: Password specified when [creating a database](#database-create).
* **Cache TTL in seconds**: `Default`.
* **Raw SQL level**: `Forbid`.
* **HTTPS**: `Enabled`.
1. Click **Create connection**.
## Create a dataset {#dataset-create}
1. Go to the [connections page](https://datalens.yandex.cloud//connections).
1. Select a [connection](#connection-create).
1. In the top-right corner, click **Create dataset**.
1. Drag one or more tables to the workspace:
* `db1.v_tracker_issues`: Current (most recent) issue cross-section.
* `db1.v_tracker_changelog`: Issue parameter change history.
* `Db1.v_tracker_statuses`: Status transition time based on the issue change history.
1. Click **Save**.
## Create a chart {#chart-create}
1. Go to the [DataLens](https://datalens.yandex.cloud/) home page.
1. Click **Create chart**.
1. In the top left corner, click **Select dataset**.
1. In the **Datasets** drop-down list, select the [dataset](#dataset-create) you created in the previous step.
1. On the top panel, select a [visualization type](https://yandex.cloud/en/docs/datalens/visualization-ref). By default, the **Column chart** type is selected.
## Create a dashboard and add charts to it {#dashboard-create}
1. On the [DataLens](https://datalens.yandex.cloud/) home page, click **Create dashboard**.
1. At the top of the [dashboard](#dashboard-create) page, click **Add** → **Chart**.
1. Fill in the widget parameters. Pay close attention to the following fields:
* **Name**: Sets the name of the widget. It is displayed at the top of the widget.
* **Chart**: Sets the widget to add.
* **Description**: Sets the description of the widget. It is displayed at the bottom of the widget.
* **Auto height**: Sets the automatic height for **Table** and **Markdown** widgets. If this parameter is disabled, you can set the height of the widget on the page using the mouse.
1. Click **Add**. The widget will be displayed on the dashboard.
1. Save the dashboard:
1. In the top-right corner of the dashboard, click **Save**.
1. Enter a name for the dashboard and click **Create**.
For more information about setting up dashboards, see [DataLens dashboard](https://yandex.cloud/en/docs/datalens/concepts/dashboard).
{% cut "Sample dashboard based on data from the `v_tracker_issues` table" %}
{% endcut %}
{% cut "Sample dashboard based on data from the `db1.v_tracker_statuses` table" %}
{% endcut %}
## How to delete the resources you created {#clear-out}
To stop paying for the resources you created:
* [Delete the ClickHouse® cluster](https://yandex.cloud/en/docs/managed-clickhouse/operations/cluster-delete).
* [Delete the Cloud Functions function](https://yandex.cloud/en/docs/functions/operations/function/function-delete).
_ClickHouse® is a registered trademark of [ClickHouse, Inc](https://clickhouse.com)._