This document provides a detailed guide on creating and configuring the Line Chart Widget within the Dashboard Details Page.

1. Creating a Line Chart Widget

1.1 Selecting the Widget

1. Click on the Line Chart Widget.
2. Other widget templates will be hidden, and the Line Chart Widget configuration fields will be displayed.

1.2 Fields for Configuration

1. Name (mandatory): Provide a unique name for the widget.
2. Data Set (mandatory):
   • Select a data set from the Table Management list.
   • The data set list supports searching for tables.
3. X-axis (mandatory):
   • The columns from the selected data set will be displayed.
   • Select a column to display data on the x-axis.
4. Y-axis (mandatory):
   • A dropdown with the following options will be displayed:
     • Count (default): Displays the count of records present in the selected x-axis column.
     • Column: If "Column" is selected, an additional field named Field will appear.

       • This field allows users to select a specific numeric column from the dataset.

       • An info icon next to the field provides the message: "The value must be numeric." on mouse hover.

       • If a non-numeric column is selected, the following error message will appear in the widget:

          Could not load data
          Error: You are trying to aggregate a text field in the widget. This is not possible.
         

1.3 Creating the Widget

1. The Create button remains disabled until all mandatory fields are filled.
2. After entering the required details, click Create.
3. The widget will display data from the selected data set.

1.4 Widget Display

1. The data from the selected data set is displayed in the Line chart as follows when Count is selected as the type in the Y-axis:
   • Example:
     • X-axis: Date column (e.g., 2024-12-27 with 7 records, 2024-01-01 with 5 records).
     • Y-axis: Count of records for each unique date is displayed.
2. The data from the selected data set is displayed in the Line chart as follows when Column is selected as the type in the Y-axis:
   • Example:

     • X-axis: Status is selected.

     • Y-axis: Net weight is selected.

     • Details:

       • Status 20: 10 records with net weights summing to 100.
       • Status 30: 5 records with net weights summing to 250.
       • Status 05: 2 records with net weights summing to 50.

       In the Line chart:

       • The X-axis displays the statuses (20, 30, 05).
       • The Y-axis displays the total net weight for each status.

1.5 Interactions

1. View Details:
   • Opens a popup showing the x-axis column and the count (y-axis).
   • Provides sorting, searching, and export options.
   • Export respects applied filters or sorting.
   • Pagination is available for large datasets.

2. Line Chart Settings Panel