# Configure Chart Series

After configuring the chart widget properties, the next step is to **define the chart series**.\
A chart series specifies **which data is plotted**, how it is filtered, and how it is represented visually on the chart.

In the Widget Dashboard architecture, chart series configuration is handled through the database table **`DASH_WIDGET_CHART_PROP`**.\
Each record in this table represents **one series** in the chart.

***

#### Chart Series Configuration via Database

To configure a chart series, insert a new record into the **`DASH_WIDGET_CHART_PROP`** table using the values shown below.

These values define:

* The chart type
* Data source and fields
* Filtering conditions
* Series order and display behavior

***

#### DASH\_WIDGET\_CHART\_PROP Table Values

| Column            | Value         |
| ----------------- | ------------- |
| ID                | `9010101`     |
| DASH\_ID          | `90101`       |
| CHART\_TYPE       | `line`        |
| TABLE\_NAME       | `MOCKUP_DATA` |
| FIELD\_NAME       | `COL2_VALUE`  |
| FIELD\_DESC       | `COL2_DESC`   |
| COND1\_FIELD      | `DASH_CODE`   |
| COND1\_VALUE      | `SA004-1`     |
| SEQ               | `1`           |
| NAME              | `INCOME`      |
| STACK\_GROUP      | *(empty)*     |
| COND2\_FIELD      | `COL1_DESC`   |
| COND2\_VALUE      | `QUARTER1`    |
| FIELD\_DESC\_SORT | *(empty)*     |
| FIELD\_PREFIX     | *(empty)*     |
| FIELD\_SUFFIX     | *(empty)*     |
| SYMBOL            | *(empty)*     |
| LEGEND            | *(empty)*     |
| FIELD\_COLOR      | *(empty)*     |
| DATA\_LABEL       | *(empty)*     |
| Y\_AXIS           | *(empty)*     |

***

#### Field Description Overview

* **ID**\
  Unique identifier for the chart series configuration.
* **DASH\_ID**\
  References the chart widget (`DASH_WIDGET_PROP.ID`) that this series belongs to.
* **CHART\_TYPE**\
  Specifies the chart type for the series (for example, `line`).
* **TABLE\_NAME**\
  Database table containing the source data for the series.
* **FIELD\_NAME**\
  Numeric field used as the chart value.
* **FIELD\_DESC**\
  Field used as the category or label description.
* **COND1\_FIELD / COND1\_VALUE**\
  Primary filter condition applied to the dataset.
* **COND2\_FIELD / COND2\_VALUE**\
  Secondary filter condition for more specific data selection.
* **SEQ**\
  Defines the display order of the series within the chart.
* **NAME**\
  Display name of the series shown in the chart legend.
* **STACK\_GROUP**\
  Used for grouping series in stacked charts (optional).
* **FIELD\_DESC\_SORT**\
  Sorting behavior for category labels.
* **FIELD\_PREFIX / FIELD\_SUFFIX**\
  Optional prefix or suffix appended to data values.
* **SYMBOL**\
  Symbol used for data points (if applicable).
* **LEGEND**\
  Controls whether the series appears in the legend.
* **FIELD\_COLOR**\
  Custom color assigned to the series.
* **DATA\_LABEL**\
  Controls whether data labels are shown.
* **Y\_AXIS**\
  Specifies which Y‑axis the series uses (primary or secondary).

***

#### Verify the Chart Series

After inserting the series configuration, return to the dashboard page:

1. Open the dashboard URL
2. Click the **Training** page (or the menu you configured previously)

The chart should now be rendered with the configured series.

***

#### Expected Result

The chart displays **Income data for the 1st quarter**, comparing values across provinces, as shown below.

<figure><img src="https://2015371994-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMpDjHWFRUtZ5nJcSfVXd%2Fuploads%2FtuXxa9ASvYVR57BCRvAE%2Fimage.png?alt=media&#x26;token=f7a325dc-19f3-41ed-8405-b1f62bfa310d" alt=""><figcaption></figcaption></figure>

***

#### Summary

By completing this step:

* The chart widget is now populated with data
* The dashboard renders a meaningful visualization
* The Widget Dashboard setup is fully functional end‑to‑end

This completes the configuration‑driven **Widget Dashboard workflow** in ONEWEB.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.onewebstack.com/building-apps/ui-page-designer/ux-ui-components/dashboard/widget-dashboard/steps-to-create-a-widget-dashboard/configure-chart-series.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.