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 could 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:
Create a Table Chart
- Run a query.
- In the Aggregates tab, the Table Chart icon is automatically selected as the default.
The data in the Aggregates tab is represented as a table chart by default.
URL Links in Table Chart Panels
If your query looks for URLs, when you create a Table Chart Panel, the URLs displayed in the table will be displayed as working links.
For example, if you used this query to search for hits to the Sumo Logic Help system:
HelpProxyServlet !grr !"Resources" !"Skins" !"Data"
| parse "uri: '*'" as url
| count url<
| sort - _count
You would see results such as the following in the Aggregates tab.
Then, use the following steps to create a Table Chart Panel.
Create a Table Chart Panel
- Click Create Panel to create a Table Chart Panel.
- When the Table Chart Panel appears in your Panel, make sure the Edit toggle is off.
- The links become live. If you click a link, it will open the displayed URL in a new tab.