Table
Last updated
Was this helpful?
Last updated
Was this helpful?
The table panel visualization is very flexible, supporting multiple modes for time series and for tables, annotation, and raw JSON data. This panel also provides date formatting, value formatting, and coloring options.
Click a column title to change the sort order from default to descending to ascending. Each time you click, the sort order changes to the next option in the cycle. You can sort multiple columns by holding the shift key and clicking the column name.
Show or hide column names imported from your data source.
By default, Algology automatically calculates the column width based on the table size and the minimum column width. This field option can override the setting and define the width for all columns in pixels.
By default, the minimum width of the table column is 150 pixels. This field option can override that default and will define the new minimum column width for the table panel in pixels.
For small-screen devices, such as smartphones or tablets, reduce the default 150 pixel value to50 to allow table based panels to render correctly in dashboards.
Choose how Algology should align cell contents:
Auto (default)
Left
Center
Right
By default, Algology automatically chooses display settings. You can override the settings by choosing one of the following options to set the default for all fields. Additional configuration is available for some cell types.
Note: If you set these in the Field tab, then the type will apply to all fields, including the time field. Many options will work best if you set them in the Override tab so that they can be restricted to one or more fields.
If thresholds are set, then the field text is displayed in the appropriate threshold color.
If thresholds are set, then the field background is displayed in the appropriate threshold color.
Cells can be displayed as a graphical gauge, with several different presentation types.
Basic
The basic mode will show a simple gauge with the threshold levels defining the color of gauge.
Gradient
The threshold levels define a gradient.
LCD
The gauge is split up in small cells that are lit or unlit.
Label Options
Additionally, labels displayed alongside of the gauges can be set to be colored by value, match the theme text color, or be hidden.
Shows value formatted as code. If a value is an object the JSON view allowing browsing the JSON object will appear on hover.
If you have a field value that is an image URL or a base64 encoded image you can configure the table to display it as an image.
Note: Modify Algology configuration file to enable the timeSeriesTable feature toggle to use it.
Shows value rendered as a sparkline. Requires time series to table data transform.
Enables value inspection from table cell. The raw value is presented in a modal window.
Note: Cell value inspection is only available when cell display mode is set to Auto, Color text, Color background or JSON View.
You can temporarily change how column data is displayed.
Use this option to enable or disable pagination. It is a front-end option that does not affect queries. When enabled, the page size automatically adjusts to the height of the table.
If you turn on the Column filter, then you can filter table options.
In Algology, navigate to the dashboard with the table with the columns that you want to filter.
On the table panel you want to filter, open the panel editor.
Click the Field tab.
In Table options, turn on the Column filter option.
A filter icon appears next to each column title.
To filter column values, click the filter (funnel) icon next to a column title. Algology displays the filter options for that column.
Click the check box next to the values that you want to display. Enter text in the search field at the top to show those values in the display so that you can select them rather than scroll to find them.
Columns with filters applied have a blue funnel displayed next to the title.
To remove the filter, click the blue funnel icon and then click Clear filter.
You can use the table footer to show calculations on fields.
After you enable the table footer:
Select the Calculation
Select the Fields that you want to calculate
The system applies the calculation to all numeric fields if you do not select a field.
If you want to show the number of rows in the dataset instead of the number of values in the selected fields, select the Count calculation and enable Count rows.