# Metrics board

## **0. Open the Metrics Board**

Click the Metrics Board button on the toolbar to open the Metrics Board.\ <br>

<figure><img src="https://2743975646-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LriZ7WXXZykpg6_MQsw%2Fuploads%2FAUOAV6dQ2oU46hfDkeKd%2Fmetrics%20board.png?alt=media&#x26;token=cbca33d2-a013-4a54-a246-73709bd93914" alt=""><figcaption><p>Open Metrics Board</p></figcaption></figure>

Metrics board settings:

<figure><img src="https://2743975646-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LriZ7WXXZykpg6_MQsw%2Fuploads%2FPF3ZIkKOXch3FzZx8o8o%2Fmetrics%20board%20settings.png?alt=media&#x26;token=f54239ab-fade-4a7f-8743-037b600b29b4" alt=""><figcaption><p>metrics board settings</p></figcaption></figure>

## 1. Create a simple bar/line chart

You can add a bar chart or a line chart by click the + button on the toolbar or using your right mouse click.

<figure><img src="https://2743975646-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LriZ7WXXZykpg6_MQsw%2Fuploads%2F5q6YDIgHtidioJPDtgi6%2Fchart.png?alt=media&#x26;token=3907eb28-e5bd-4b81-b663-211e243bcf58" alt=""><figcaption><p>simple bar chart</p></figcaption></figure>

* Click the object to show the settings.
* Enter the SQL Query, Ex: SELECT 2 as a;
* Config the refresh rate:\
  \- After xx seconds: The chart will be reloaded after xx seconds.\
  \- Refresh on event: The chart will be reloaded on an event (which is sent from an input field).\
  \- Do not refresh: The chart will not be reloaded, you can reload it manually by click the refresh button at the bottom left.

## 2. Create a data table view

The data view config is similar to charts

<figure><img src="https://2743975646-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LriZ7WXXZykpg6_MQsw%2Fuploads%2FZaImu0Jv0vByrXiJ4U8c%2Ftable.png?alt=media&#x26;token=d05f9d04-8172-490b-91aa-39e725eb43a9" alt=""><figcaption></figcaption></figure>

## 3. Create an input field

Before creating an input field, you must create a chart or a table data view, which has query parameters and the refresh rate: Refresh on Event.

<figure><img src="https://2743975646-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LriZ7WXXZykpg6_MQsw%2Fuploads%2FeO3UfU6IFaVT8rQt3ph5%2Ftable-input.png?alt=media&#x26;token=074ab383-515c-4e7a-8052-0d85dc69a8ac" alt=""><figcaption><p>data view with a query parameter</p></figcaption></figure>

Create an input field

<figure><img src="https://2743975646-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LriZ7WXXZykpg6_MQsw%2Fuploads%2FAG5ZiKzZY6BURSFvczqY%2Finput%20field.png?alt=media&#x26;token=0ccce80d-6f71-431b-984c-2db9b779bd21" alt=""><figcaption><p>input field</p></figcaption></figure>

* You must config the name of the variable.
* You must create a connection to the object.
* The object must have the refresh rate: Refresh on Event.
