--- id: table-charts title: Table Charts description: Use table charts in Sumo Logic dashboards to display aggregated search results, listing event types and counts using group-by queries in the Aggregates tab. slug: /help/docs/dashboards/panels/table-charts/ canonical: https://www.sumologic.com/help/docs/dashboards/panels/table-charts/ --- import useBaseUrl from '@docusaurus/useBaseUrl'; Table charts are the default chart type in the **Aggregates** tab. They are useful for listing the type and number of events that have occurred, such as the type of error that occurs the most in your system. To create a table chart, use a search query that provides at least a few data points in the **Aggregates** tab. For example, you'd use the following query to create a simple table chart: `(error OR fail*) AND exception | count by _sourceCategory | sort by _count` which would produce results such as:
AggResult ## Create a table chart  To add a panel with a table chart: 1. Create or open a Dashboard and click on **Add Panel > Time Series** or **Add Panel > Categorical**.
time series or categorical 1. Provide a Metric or Log query and press **Enter** for it to run. You can create Log and Metric queries on the same panel. **Log query:** Enter your aggregate [search query](/docs/search/search-query-language/group-aggregate-operators) in the input field and press enter. Only search results that have been aggregated using a group or aggregate operator can be charted. See [Group or Aggregate Operators](/docs/search/search-query-language/group-aggregate-operators) for a list.
Add log query **Metrics query:** Click the left-most dropdown option and select **Metrics**. You should be familiar with the basics of creating [metrics queries](/docs/metrics/metrics-queries) to ensure successful results. By default, the query builder is set to **Logs**.
Metrics selection for query builder To create a metrics query utilize the [Metrics Search](/docs/metrics/metrics-queries). 1. Once the query runs, you will need to flip the chart type to **Table**. 1. (Optional) **Missing Data Display**. Enter the text that needs to be displayed when data is missing. 1. (Optional) **Font Size**. Font size of the text displayed. By default, `12` is set as font size. You can change this based on your requirement. 1. (Optional) **Decimals**. Sets the precision of units displayed. Select the number of decimals to show with a unit, up to 10. 1. (Optional) **Rows Per Page**. Set the numbers of rows to display in the table.
new table chart 1. [Modify the chart](./modify-chart.md) as desired. 1. Click the **Add to Dashboard** button on the top right of the window to add the panel to your dashboard.
Add to Dashboard button ## URL Links in table chart panels When you create a table chart panel, and if your query looks for URLs, then use the [`tourl`](/docs/search/search-query-language/search-operators/tourl/) operator to display the URL in the table as working links. For example, if you used this query to search for hits to the Sumo Logic Help system: ```sumo _sourceCategory=aws/cloudtrail  | keyvalue "LoginTo"  | count loginto | sort - _count ``` You would see results such as the following in the **Aggregates** tab.
URLTable Then, follow the steps in the previous section to create a table chart panel.