Activeboards / Working with Activeboard widgets / Table widgets

Table widgets

The table widget displays data as a simple table, distributed in columns and rows.

This is the source query used to generate the above widget:

query(

from demo.ecommerce.data group every 5m by statusCode

)

Table widgets are uniquely equipped to do double-duty in your Activeboard as both widgets for the display of key data and as inputs for filtering data in other widgets.

When used as a filter, you can select a cell in a table widget, and filter a different widget in the Activeboard based on the selected cell's value. Let's take the example of a table that simply lists the count of GET and POST requests over the Activeboard time range. When used as a filter, you can select the GET cell to make another widget only display its results where the HTTP method is GET.

To do so, you need to edit the query of the other widget (not the table widget's query) to set the field name equal to the value of the cell you select in the table:

Query script	Example	Sample widget query
`$table_namespace.cellClicked`	`$Table1.cellClicked`	query( from demo.ecommerce.data where method=$Table1.cellClicked)

What data do I need for this widget?

Any kind of data will work, so you don't need any specific data fields or operations in your query.

Widget settings

The widget settings are contained in the Data and Visual tabs. The settings in the Data tab are described in the Create a widget article.

These are the visual settings for the area chart:

Category	Setting	Description
General	Enable sorting	Activate this option to enable sorting for table columns.
	Column Resize	Activate this option to enable column resizing.
	Filter	Activate this option to add a filter to each column header that you can use to display only the data you need.
	Pagination	In cases you have a large amount of data, you can activate this option to separate the table content into different pages.
Columns	This group of settings enable you to customize the individual characteristics of each column.
	Name	The name of the column. This will appear in the column header.
	Hide	Activate this option to hide the column in the table.
	Format	Select the format of the column values. The available options are: Default - Standard format of the column values. Date - Apply a date format. Conditional - Create sets of conditions to modify the background color or show an icon for those column values that meet specific criteria. Sparkline - Display a small, simple line chart representing the column data. This option only appears if you include a specific query pattern in your table widget. See details below. Column - Represent data as a simple set of columns. This option only appears if you include a specific query pattern in your table widget. See details below.

Add sparklines and column charts to a table widget

As said above, the Sparkline and Column format options represent data as simple, embedded charts intended to check data trends at a glance. To make the Sparkline and Column options available, you must add the following query structure to your table widget:

sparkline(
query(),
query(),
["", ""],
["", ""]
)

You need to enter two different queries between brackets, preceded by sparkline. This allows you to represent values from two different queries (from the same or different data tables).

The first query must contain the grouping keys you want to represent as simple values.
The second query must contain the values you want to represent as an embedded sparkline or column graph, so you need to aggregate the data (for example, including a count). After creating your table widget, you must click its header, select Visual and go to the Columns category. There you must select Sparkline or Column in the Format setting of the required columns.
Finally, you must include the names of the grouping fields and columns resulting from the aggregation between brackets.

If you use queries from two different tables when using the sparkline syntax, the grouping fields in both queries must have the same name.

Example 1

sparkline(
query(from demo.ecommerce.data group every 0 by method, statusCode),
query(from demo.ecommerce.data group every 1m by method, statusCode
select count() as Sparkline
select count() as Columns
select min(bytesTransferred) as MinimumTransferredBytes),
["method", "statusCode"],
["Sparkline", "Columns", "MinimumTransferredBytes"]
)

In this example, we use the first query to group the data in the method and statusCode columns and display the results in the table. The second query includes the values you want to display as embedded graphs in your table, which will display after we select either the Sparkline or Column setting options, as explained above.

We have represented the count for each group every minute both as a sparkline and a column chart. Plus, we have included a column to represent the minimum number of bytes transferred for each group every minute.

Example 2

sparkline(
query(from demo.ecommerce.data group every 0 by statusCode, method),
query(from web.all.access group every 5m by statusCode, method
select count() as columnChart
),
["statusCode", "method"],
["columnChart"]
)

In this example, we are displaying data from two different tables. We use the first query (demo.ecommerce.data) to group the data in the statusCode and method columns and display the results as values in the table. The second query (web.all.access) groups two fields with the same name as in the first query, and aggregates the data to add a count column (named columnChart), which we will represent as an embedded column chart.

Tips for using a table widget

Here are a few tips to get the most out of your table widget.

Hover over the end of a column header and click the icon that appears to access the following setting options:

Pin column	Select this option to freeze the column, thus making it always visible while you use the vertical scroll bar of the table. Select between Pin left, Pin right or No pin.
Autosize this column	Apply the best width to fit the contents of the cells in the column.
Autosize all columns	Apply the best width to all the columns in the table.
Reset columns	Restore the original size of the columns.

Hover over the end of a column header, select the icon that appears, then click this icon to select the columns you want to display or hide in the table.
If you have selected the Sorting option in the table visual settings you can click a column header to sort its content in ascending order, or click it again for a descending sort. Return to the original order clicking the header again.
After selecting the Filter option in the table visual settings, you can filter the table data. Hover over the end of a column header and click the icon that appears, then select the filter icon. Search for the values you want to display in the search box and check their boxes from the list.
You can resize columns as required after selecting the Column Resize option in the table visual settings.
Select a cell or several ones, right-click them and select Copy to copy them to your clipboard. Select Copy with Headers to add the corresponding headers.
Right-click any cell and select Export to export the table content. Choose from CSV Export, Excel Export (.xlsx) and Excel Export (.xml).

Download as PDF

Did you find what you were looking for?

If not, please let us know what you need. Your feedback will help us to improve.