---
schema_version: "1"
id: 08d0af26f46e6514a1d1495a152d3aec7e2e8da043aec6b4a1761dd01f9aad94
title: Configuring Tables in a Custom Dashboard
collection: mulesoft
version: current
locale: en-us
portal_url: https://docs.salesforce.com/mulesoft/current/en-us/monitoring/dashboard-custom-config-table.md
canonical_url: https://docs.mulesoft.com/monitoring/dashboard-custom-config-table
source_site: docs.mulesoft.com
content_type: documentation
content_hash: 1e6d3d84c3026681d5a1f32a4f3874492e0a661b06d114603d778fa86225b552
description: Configure table charts in MuleSoft Anypoint Monitoring custom dashboards to display detailed metric data for Mule apps and APIs in tabular format.
latest: true
---
---
product: Monitoring
description: Configure table charts in MuleSoft Anypoint Monitoring custom dashboards to display detailed metric data for Mule apps and APIs in tabular format.
keywords: MuleSoft, Anypoint Monitoring, custom dashboards, table chart, tabular metrics, dashboard visualization, Mule app metrics, API metrics
---

# Configuring Tables in a Custom Dashboard

> For the full documentation index, see: https://docs.mulesoft.com/llms.txt

[![](/mulesoft/current/en-us/_/img/icons/info.svg)](/monitoring/#billing)

Configure tables with Mule app and API metrics in Anypoint Monitoring custom dashboards.

![Table chart and configuration view](/mulesoft/current/en-us/monitoring/_images/dashboard-custom-config-table.png)

<table><tbody><tr><td><i data-value="1"></i><b>1</b></td><td>A table configured with multiple queries in advanced mode</td></tr><tr><td><i data-value="2"></i><b>2</b></td><td>Table configuration tabs:<div><ul><li><p><a href="#general"><strong>General</strong></a>: Table title, description, and mode (basic or advanced)</p></li><li><p><a href="#time-range"><strong>Time range</strong></a>: Override settings for relative time ranges selected from the dashboard UI by end users</p></li><li><p><a href="#options"><strong>Options</strong></a>: Table layout, column, and pagination options</p></li><li><p><a href="#column-styles"><strong>Column Styles</strong></a>: Rules for table columns</p></li><li><p><strong>X</strong> for closing the edit view</p></li></ul></div></td></tr><tr><td><i data-value="3"></i><b>3</b></td><td><strong>Advanced Mode</strong>: Switch for enabling <a href="#mode_advanced">advanced</a> configuration mode<div><p>Advanced mode support complex configurations with up to 25 queries.</p></div></td></tr><tr><td><i data-value="4"></i><b>4</b></td><td>Icons for moving, duplicating, and deleting queries from an advanced mode configuration</td></tr></tbody></table>

## Create a Table

Create a table in a custom dashboard by following the guidance in
[Add Charts to a Custom Dashboard](https://docs.mulesoft.com/monitoring/dashboard-custom-config#charts_adding).

## Configure a Table

Configure a table in a custom dashboard.

1.  From **Custom Dashboards**, open the custom dashboard that contains your table.

    For guidance, see [View a Custom Dashboard](https://docs.mulesoft.com/monitoring/dashboard-custom-config#view).

2.  Click the table’s ![](/mulesoft/current/en-us/monitoring/_images/more-menu-vert-ellipsis.png) (**More menu**), and select
    **Configure**.

3.  Click the table’s **General** configuration tab.

    1.  Provide a title and description.

    2.  Select and configure a table mode (basic or advanced).

        Both modes require environment, resource (app or API), and metric settings. For more
        information, see [General Settings for Basic and Advanced Queries](#general).

4.  Optionally:

    1.  In the table’s [**Time range**](#time-range) tab, set the table’s overrides for the time
        range selected by users.

    2.  In the [**Options**](#options) tab, configure table layout, column, and pagination options.

    3.  In the [**Column Styles**](#column-styles) tab, set rules for table columns.

5.  Click **Apply Changes**.

6.  Exit the configuration view by clicking the **X** next to the configuration tabs.

## General Settings for Basic and Advanced Queries

**General** tab settings include [basic](#mode_basic) and [advanced](#mode_advanced) modes (or
queries) for configuring time-series data. Both configurations share fields for the title and a
short description.

<table><colgroup><col> <col></colgroup><thead><tr><th colspan="2">Basic and Advanced Mode Settings</th></tr></thead><tbody><tr><td><p><strong>Title</strong></p></td><td><p>Title to display in the UI. Defaults to Panel Title.</p></td></tr><tr><td><p><strong>Description</strong></p></td><td><p>Short description to display in the UI when users hover over the information (<code>i</code>) bubble.</p></td></tr></tbody></table>

Other settings are specific to the setting mode (basic or advanced).

### Basic Mode

In the **General** configuration tab, a basic query selects a single metric for a deployed Mule app
or API in a given environment.

<table><colgroup><col> <col></colgroup><thead><tr><th colspan="2">Basic Mode Settings</th></tr></thead><tbody><tr><td><p><strong>Panel Type</strong></p></td><td><div><div><p>From the drop-down menu, select the type of panel to display for the resource (<strong>Application Panel</strong> or <strong>API Panel</strong>)</p></div></div></td></tr><tr><td><p><strong>Metric</strong></p></td><td><div><div><p>The drop-down menu includes these types of metrics:</p></div><div><ul><li><p>Inbound response metrics and averages</p></li><li><p>JVM metrics</p></li><li><p>Outbound response metrics and averages</p></li></ul></div><div><p>For a list of basic metrics, see <a href="https://docs.mulesoft.com/monitoring/dashboard-config-ref#metrics">Basic Mode Metrics</a></p></div></div></td></tr><tr><td><p><strong>Environment</strong></p></td><td><p>The environment where your application or API is deployed.</p></td></tr><tr><td><p><strong>Resource</strong></p></td><td><p>A deployed application.</p><p>This option is available if you select <strong>Application Panel</strong> as your panel type.</p></td></tr><tr><td><p><strong>API</strong></p></td><td><p>A deployed API.</p><p>This option is available if you select <strong>API Panel</strong> as your panel type.</p></td></tr><tr><td><p><strong>Version / Instance</strong></p></td><td><p>The Mule version or instance on which your API is deployed.</p><p>This option is available if you select <strong>API Panel</strong> as your panel type.</p></td></tr></tbody></table>

> [!NOTE] When you create an application panel using a JVM metric, the query that supports the panel
> uses only the worker-id for the app. When you modify the panel at a later time, the resource
> fields are populated with the query content. Because some apps share a worker-id, the resource
> that appears in the selector might appear to be a different resource from the resource you
> selected originally. However, all resources share the same worker, so the query has the correct
> information despite the selector displaying a different resource name.

### Advanced Mode

In the **General** configuration tab, advanced mode settings support fine-tuned queries for metrics.

> [!IMPORTANT] If you switch back to basic mode, some advanced configuration queries are removed.

![Advanced configuration mode is on.](/mulesoft/current/en-us/monitoring/_images/config-general-advanced.png)

<table><colgroup><col> <col></colgroup><thead><tr><th colspan="2">Advanced Mode Settings for Applications</th></tr></thead><tbody><tr><td><p><strong>From</strong></p></td><td><div><div><p>Lists metrics, such as <code>jvm.memory</code> and <code>app_inbound_metric</code>, that you can add to your chart.</p></div><div><p>This field provides matching suggestions when you type in a character. For example, <code>jvm.c</code> will produce a list of all values that contain those characters (such as <code>jvm.classloading</code> and <code>jvm.cpu.operatingsystem</code>).</p></div><div><p>For a list of advanced metrics, see <a href="https://docs.mulesoft.com/monitoring/dashboard-config-ref#metrics_advanced">Advanced Mode Metrics</a></p></div></div></td></tr><tr><td><p><strong>Where</strong></p></td><td><div><div><p>Supports conditional logic for filtering the <strong>From</strong> metric you selected.</p></div><div><ul><li><p>Select one or more filters tags (such as <code>app_id</code>, <code>env_id</code>, <code>org_id</code>, <code>worker_id</code>). To avoid errors, you must provide required properties, such as the app or API, environment, and API version.</p></li><li><p>Available operators include:<br></p><div><ul><li><p><code>=</code> The value on the left matches the value on the right.</p></li><li><p><code>&lt;</code> The value on the left is less than the value on the right.</p></li><li><p><code>&gt;</code> The value on the left is greater than the value on the right.</p></li></ul></div></li><li><p>You can also construct a query that contains multiple filtering expressions by using logical <code>AND</code> or <code>OR</code> operators between the expressions.</p><div><p>Example:</p></div></li><li><p><code>Where env_id = Sandbox</code></p></li><li><p><code>Where env_id = Sandbox AND app_id= app3</code></p></li><li><p><code>Where env_id = Sandbox OR env_id = Production</code></p></li></ul></div><div><p>Grouping <code>AND</code> or <code>OR</code> conditions within parentheses is <em>not allowed</em>. For example, <code>Where env_id = Sandbox AND (app_id= app3 OR app_id=app2)</code> isn’t allowed.</p></div></div></td></tr><tr><td><p><strong>Select</strong></p></td><td><div><div><p>Add one or more metric <code>field</code> settings to create a function that selects a field from the selected metric value in <strong>From</strong> and applies an operation to it (such as the <code>mean</code> of the <code>heap_total</code>).</p></div></div></td></tr><tr><td><p><strong>Group By</strong></p></td><td><div><div><p>For grouping the data by a selected time interval (such as <code>$_interval</code>, <code>1s</code>, <code>10m</code>, <code>1h</code>), filter tag (such as <code>tag(env_id)</code>), and fill options (such as <code>none</code>, <code>null</code>, <code>0</code>, <code>previous</code>, <code>linear</code>).</p></div><div><p>Valid values and arguments:</p></div><div><ul><li><p><code>time($_interval)</code> for the automated time interval setting, or you can specify time intervals of <code>1m</code>, <code>5m</code>, <code>10m</code>, <code>15m</code>, or <code>1h</code>.</p><div><ul><li><p>To avoid service timeouts when querying over long time ranges, consider using a time interval setting.</p></li></ul></div></li><li><p><code>fill()</code> where valid values are <code>none</code>, <code>null</code>, <code>0</code>, <code>previous</code>, <code>linear</code>.</p></li><li><p><code>LIMIT</code>: Numeric value (N) used to limit the result to the first N data points (combined series and timestamp values) returned by a query.</p></li><li><p><code>SLIMIT</code>: Numeric value (N) used to return all data points (combined series and timestamp values) from the first N series returned by the query.</p></li><li><p><code>ORDER BY time DESC</code>: Returns results in descending time order.</p></li></ul></div></div></td></tr><tr><td><p><strong>Alias By</strong></p></td><td><p>You can create a label for your metric using a literal string (such as <code>my string</code>) or supported variables (for example, <code>$tag_worker_id</code> or <code>$tag_env_id</code>).</p></td></tr></tbody></table>

<table><colgroup><col> <col></colgroup><thead><tr><th colspan="2">Advanced Mode Settings for APIs</th></tr></thead><tbody><tr><td><p><strong>From</strong></p></td><td><div><div><p>Lists metrics, such as <code>http_summary_metric</code>, that you can add to your chart.</p></div><div><p>For a list of advanced metrics, see <a href="https://docs.mulesoft.com/monitoring/dashboard-config-ref#metrics_advanced">Advanced Mode Metrics</a></p></div></div></td></tr><tr><td><p><strong>Where</strong></p></td><td><div><div><p>Provides conditional logic for filtering the metric selected from the <strong>From</strong> field.</p></div><div><p>You can select one or more filter tags (such as <code>api_id</code>, <code>org_id</code>, <code>api_version_id</code>, <code>method</code>, <code>status code</code>). Example: <code>Where status_code = 200</code>.</p></div></div></td></tr><tr><td><p><strong>Select</strong></p></td><td><div><div><p>For creating a function that selects a metric field (such as <code>request_size_average</code>,<code>response_time_max</code>, or <code>response_time_sum</code>) from the metric selected in the <strong>From</strong> field and applies an operation to it (such as the <code>mean</code> of the <code>response_time_average</code>). You can add one or more metric <code>field</code> settings.</p></div></div></td></tr><tr><td><p><strong>Group by</strong></p></td><td><div><div><p>For grouping the data by a selected time interval (such as <code>$_interval</code>, <code>1s</code>, <code>10m</code>, <code>1h</code>), filter tag (such as <code>tag(api_id)</code>), and fill options (such as <code>none</code>, <code>null</code>, <code>0</code>, <code>previous</code>, <code>linear</code>).</p></div><div><ul><li><p>To avoid service timeouts when querying over long time ranges, consider using a time interval setting.</p></li></ul></div></div></td></tr><tr><td><p><strong>Alias by</strong></p></td><td><div><div><p>You can create a label for your metric using a literal string (such as <code>my string</code>) or supported variables (for example, <code>$tag_api_id</code>). The alias must always begin with <code>$tag</code>. The syntax is <code>$tag_yourTagName</code>.</p></div><div><p>To use your tag as an alias, the tag must be included in the <code>group by</code> field of the query.</p></div></div></td></tr></tbody></table>

## Time Range (Overrides, Time Shifts, Info Display)

Time range configurations provide a way to override _relative_ time ranges (such as the last 30
minutes) selected from the dashboard UI by end users.

<table><colgroup><col> <col></colgroup><thead><tr><th colspan="2">Time Range Settings</th></tr></thead><tbody><tr><td><p><strong>Override Relative Time</strong></p></td><td><p>The amount of time covered by the statistic, for example, the last hour (<code>1h</code>) or last thirty minutes (<code>30m</code>). This setting overrides only <em>relative</em> time ranges selected by end users. When a user selects an <em>absolute time and date range</em> for the dashboard, the override is disabled.</p></td></tr><tr><td><p><strong>Add Time Shift</strong></p></td><td><p>How long ago the covered time range ended, for example, <code>1s</code> for one second ago.</p></td></tr><tr><td><p><strong>Hide Time Override Info</strong></p></td><td><p>Hides information about the override time range settings from the singlestat or table, such as <code>30 minutes, ending 1 second ago</code>.</p></td></tr></tbody></table>

## Options (Data and Pagination Settings)

In the **Options** configuration tab, you can set layout, column, and pagination options for tables
in a custom dashboard.

### Data Settings (Options tab)

Provide time series data transformation, column, and paging configurations.

<table><colgroup><col> <col></colgroup><thead><tr><th colspan="2">Value Settings</th></tr></thead><tbody><tr><td><p><strong>Time Series to Rows</strong></p></td><td><div><div><p>Creates a table with values for a given metric at a given time period. Like Time Series to Columns, the first column, Time, is for timestamps (such as <code>2018-04-25 06:37:40</code>). However, subsequent columns are Metric (for listing specific metrics, such as <code>worker-0</code>) and Value for listing the values of the metric at that time period.</p></div></div></td></tr><tr><td><p>Time Series to Columns</p></td><td><div><div><p>Creates a table that shows values for a given metric at a given time period. Like Time Series to Rows, the first column, Time, is for timestamps. However, there is a column for each metric, such as <code>worker-0</code>, which lists the values of that metric at a given time period.</p></div></div></td></tr><tr><td><p>Time Series to Aggregations</p></td><td><div><div><p>Transforms time series into a table that calculates totals, averages, and so on for a given metric. The first column, Metric, is for metrics such as <code>worker-0</code>, and subsequent columns are for any combination of these values: Avg, Min, Max, Total, Current, or Count for a given metric.</p></div><div><p>Note that this example uses color-coded <a href="#thresholds">thresholds</a> (see the cell coloring in the Avg and Max cells and value coloring for the Min value).</p></div></div></td></tr></tbody></table>

If you select Time Series to Aggregations, you can add pre-defined columns to the table.

<table><colgroup><col> <col></colgroup><thead><tr><th colspan="2">Columns for Aggregations</th></tr></thead><tbody><tr><td><p><strong>Auto</strong></p></td><td><p>Columns and their order are determined by the data query. Only available setting when Time Series to Rows, Time Series to Columns, Annotations, or Table is selected.</p></td></tr><tr><td><p><strong>Avg</strong></p></td><td><p>Averages the recorded data for a given metric.</p></td></tr><tr><td><p><strong>Min</strong></p></td><td><p>Provides the lowest recorded value for a given metric.</p></td></tr><tr><td><p><strong>Max</strong></p></td><td><p>Provides the highest recorded value for a given metric.</p></td></tr><tr><td><p><strong>Total</strong></p></td><td><p>Provides the sum of all values recorded in the table.</p></td></tr><tr><td><p><strong>Current</strong></p></td><td><p>Shows the current value for a given metric.</p></td></tr><tr><td><p><strong>Count</strong></p></td><td><p>Provides the total number of data points collected on the metric.</p></td></tr></tbody></table>

### Paging (Options tab)

In the **Options** configuration tab, you can set pagination properties for tables so they don’t
become too long and are more manageable.

<table><colgroup><col> <col></colgroup><thead><tr><th colspan="2">Paging Properties</th></tr></thead><tbody><tr><td><p><strong>Rows per Page</strong></p></td><td><p>Number of table rows allowed per page.</p></td></tr><tr><td><p><strong>Scroll</strong></p></td><td><p>Checkbox for making the table scrollable.</p></td></tr><tr><td><p><strong>Font Size</strong></p></td><td><p>Percentage of the default font size from 80% to 250%.</p></td></tr></tbody></table>

## Column Styles (Options, Data Types, Thresholds, Links)

In the **Column Styles** configuration tab, you can create (**+Add**) and apply rules available for
table columns.

To remove a rule, you need to click it, then find and click the Remove Rule button near the bottom
left of the screen.

### Options (Column Styles tab)

<table><colgroup><col> <col></colgroup><thead><tr><th colspan="2">Options</th></tr></thead><tbody><tr><td><p><strong>Apply To Columns Named</strong></p></td><td><p>Identifies the column or columns to which the rule applies. Provide the name or a regular expression (regex) that matches the name of one or more columns in the table. For a regex, use this syntax: <code>/my.*regex/</code></p></td></tr><tr><td><p><strong>Column Header</strong></p></td><td><p>Provides a title for the column. For example, if you add the <code>Avg</code> column to a table that aggregates data, you might change the column name to <code>Average</code>. You can use strings such as <code>$1</code> for a regular expression.</p></td></tr><tr><td><p><strong>Render Value As Link</strong></p></td><td><p>Treats values in the column as a link that you can configure through the <a href="#settings_link">Link</a> settings.</p></td></tr></tbody></table>

### Link (Column Styles tab)

In the Column Styles configuration tab, you can configure a link from a value to a specified web
page.

Link settings are available only when _Render Value As Link_ is checked.

<table><colgroup><col> <col></colgroup><thead><tr><th colspan="2"><strong>Link</strong></th></tr></thead><tbody><tr><td><p>URL</p></td><td><div><div><p>Specifies a URL that you can open when you click a value in the column.</p></div></div></td></tr><tr><td><p><strong>Tooltip</strong></p></td><td><div><div><p>For providing a description of the link. This text appears when the end user hovers over the cell with the link. Use the same variables as for URL.</p></div></div></td></tr><tr><td><p>Open In New Tab</p></td><td><p>Displays the web content in a new browser tab when you click on the value.</p></td></tr></tbody></table>

<table><colgroup><col> <col></colgroup><thead><tr><th colspan="2">Type</th></tr></thead><tbody><tr><td><p><strong>Type</strong></p></td><td><p>Data type for values in the column. Valid values are Number, String, Date, and Hidden.</p></td></tr><tr><td><p><strong>Unit</strong></p></td><td><p>Label for the unit of measure to use for the value, such as <code>bytes</code> and <code>megabytes/second</code>. It is important to know the data type for your value before adding this label to the value. A wide variety of units are available.</p></td></tr><tr><td><p><strong>Decimals</strong></p></td><td><p>The level of precision allowed for a decimal value, for example, <code>2</code> to limit a value of <code>10.12345</code> to <code>10.12</code>.</p></td></tr></tbody></table>

### Thresholds (Column Styles tab)

In the Column Styles configuration tab, you can set thresholds for your data if Type is set to
Number.

<table><colgroup><col> <col></colgroup><thead><tr><th colspan="2"><strong>Thresholds</strong></th></tr></thead><tbody><tr><td><p><strong>Thresholds</strong></p></td><td><p>Comma-separated values, for example, <code>50000000,100000000</code>. Values between the two values might be treated as warning values. Values below the first value might be treated as acceptable, while values above the second value might be treated as errors. Note that your threshold values must match the unit of measure used for your data (for example, <code>byte</code>) <em>even if the specified Unit is converted to MB or GB in the table</em>.</p></td></tr><tr><td><p><strong>Color Mode</strong></p></td><td><p>Indicates whether to apply the color code to the Value in a cell, to the Cell, to the entire Row, or whether color coding is Disabled.</p></td></tr><tr><td><p><strong>Color</strong></p></td><td><p>Color used to code values below (left-most color box), between (middle color box), and above (right-most color box) the specified threshold settings. For example, green values might represent OK, yellow a warning, and red an error. You can also invert the color coding.</p></td></tr></tbody></table>