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.
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.