Change the chart to column stacked chart

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.

Last updated