Change chart to column stack
Insert another record into table DASH_WIDGET_CHART_PROP following these values
ID
9010102
DASH_ID
90101
CHART_TYPE
column
TABLE_NAME
MOCKUP_DATA
FIELD_NAME
COL2_VALUE
FIELD_DESC
COL1_DESC
COND1_FIELD
DASH_CODE
COND1_VALUE
SA004-1
SEQ
3
NAME
KONKHEAN
STACK_GROUP
UP_COUNTRY
COND2_FIELD
COL2_DESC
COND2_VALUE
KONKHEAN
FIELD_DESC_SORT
FIELD_PREFIX
FIELD_SUFFIX
SYMBOL
LEGEND
FIELD_COLOR
DATA_LABEL
Y_AXIS
To change series type form Line to Column. Update column CHART_TYPE of table DASH_WIDGET_CHART_PROP of the previous 2 records to "column"
To create stacked group BANGKOK. Update column STACK_GROUP of table DASH_WIDGET_CHART_PROP of BANGKOK to "BANGKOK"
To add Chiang Mai to stacked group UP_COUNTRY. Update column STACK_GROUP of table DASH_WIDGET_CHART_PROP of CHIANGMAI to "UP_COUNTRY"
To change chart type to Column stacked. Update column DASHTYPE of table DASH_WIDGET_PROP of your widget to "stacked_group_column"
Click the training page again. The screen should be shown look like this picture. The new chart represents Income comparison between Bangkok and up country by quarter in Column chart.