Change chart to column stack


  • Insert another record into table DASH_WIDGET_CHART_PROP following these values


Column

Value

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.