> For the complete documentation index, see [llms.txt](https://docs.tableplus.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tableplus.com/gui-tools/metrics-board.md).

# Metrics board

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

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

<figure><img src="/files/ej6kpiDYHDfGclecjXtF" alt=""><figcaption><p>Open Metrics Board</p></figcaption></figure>

Metrics board settings:

<figure><img src="/files/Q4j9FMU8Mu4Ervpts4jR" 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="/files/kr1JI4EPBde9wv9M7XYM" 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="/files/HwtHqb93H58R0jDsqBN9" 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="/files/2SzDtjGdWh8X1wdBNKLP" alt=""><figcaption><p>data view with a query parameter</p></figcaption></figure>

Create an input field

<figure><img src="/files/dDR7Mn7NKkkVqbq3q3NR" 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.
