In case of a more complex query, aggregations are calculated based on sampled values and are approximations.
Create a Data Table
Create a customized data table and visualize logs or metrics.
STEP 1. In a custom dashboard, drag and drop the Data Table widget from your left-hand side bar to get started.
STEP 2. Set the definitions for your Data Table in the right-hand sidebar.
Name & Description. Create a name and description for your data table.
Source. Select a data source.
Coralogix supports metrics, logs and spans as the data source for the data table widget. The metrics data source provides you with the ability to investigate any metric easily despite the volume of information given. It enables you to view all the permutations of each label for a given query. Each permutation gives you the values for the selected timespan including Last, Min, Max, Avg and Sum. It includes a view that lets you see the values at any given time in the selected timespan.
If the Source chosen is metrics, specify the metric or desired PromQL in the Query field.
Table Type. When using logs or spans as the data source, you can choose between the Events view and the Aggregated view. Metrics are automatically generated in aggregated view.
Event tables show a table with a list of logs or spans ordered by time (you can change this to be sorted by other columns later) with additional metadata and labels relevant to those events, similar to the view you see in the Explore screen.
Aggregation tables creates a table of values, grouped by a field or fields you specify. Each column represents a different value depending on the chosen group. Values could be a simple count or an average of the values for the specific field, for each of the defined group-by values.
You can add and edit columns and filters for the aggregation table using the right-hand side bar.
Note: Traces are currently limited to a single aggregation column per table widget.
Columns. Manage columns by selecting one or more relevant fields.
Advanced: Select the number of results to be displayed per page.
STEP 4. In the bottom Query bar, add a Lucene or PromQL query to filter specific information.
STEP 5. If you wish to save your dashboard with the new widget, click SAVE in the upper right hand corner.