Displaying Data in a Structured Table

The Table Chart allows you to display detailed data in a structured, tabular format. It is particularly useful for viewing raw records, detailed breakdowns, or custom reports where precision and row-level insights are essential.

Fields for Configuration

To set up the Table Chart, configure the following fields:

1. User Document
   Connect to the data document from which the table data will be pulled.

2. Projection
   Select the specific field from the data document to include as table columns.

3. Date Data Connection
   Select the date field to filter or sort the table data.

4. Limit Results
   
   

Chart Configuration

After setting up the fields, complete the table configuration with the following options:

1. Option Name

   • Provide a clear and descriptive name for the table chart configuration.

   • Example: “Top 10 Sales Orders” or “Pending Invoices.”

2. Columns

   • Select the data fields that will act as the table’s columns.

   • Example: “Order ID,” “Customer Name,” “Amount,” or “Order Status.”

3. Operator

   • Choose the operation to perform on the data (if applicable):

     • Count: Total count of entries.

     • Sum: Aggregate numerical data, such as total revenue.

     • Avg: Calculate the average value of a numerical field.

4. Sort

   • Define the sorting order for the table:

     • Field: Select the column to sort by.
       Example: “Amount” or “Order Date.”

     • Order:

       • 1: Ascending order.

       • -1: Descending order.

By configuring these options, the Table Chart displays your data in a structured and customizable format, enabling detailed analysis of records, metrics, and trends.