To add another series, change chart type back to Line chart.

  • To change chart type form Pie to Line. Update column DASHTYPE of table DASH_WIDGET_PROP of the record to "line".


  • To change series type form Pie to Line. Update column CHART_TYPE of table DASH_WIDGET_CHART_PROP of the record to "line".


  • Insert another record into table DASH_WIDGET_CHART_PROP following these values.


Column

Value

ID

9010102

DASH_ID

90101

CHART_TYPE

line

TABLE_NAME

MOCKUP_DATA

FIELD_NAME

COL2_VALUE

FIELD_DESC

COL1_DESC

COND1_FIELD

DASH_CODE

COND1_VALUE

SA004-1

SEQ

2

NAME

CHAINGMAI

STACK_GROUP


COND2_FIELD

COL2_DESC

COND2_VALUE

CHAINGMAI

FIELD_DESC_SORT


FIELD_PREFIX


FIELD_SUFFIX


SYMBOL


LEGEND


FIELD_COLOR


DATA_LABEL


Y_AXIS



Click the training page again. The screen should be shown look like this picture.

The new chart represents Income comparison between Bangkok and Chaingmai by quarter.