Adding Configuration using ActiveColumns

1: Overview

ActiveColumns and ActiveRows can be used to provide user configuration on customizing datagrid content. Selectors can be used to provide a dynamic list of which columns or rows should be 'active' (i.e. shown)

ActiveSeries also works the same way with charts.

2: CDL

widgetdataGrid#dataGridWidget {
    label: "ActiveCols for Column Selection"
    size: halfwidth

//selectors for columns

    select#selcol {
      label: "Select columns"
      defaultOption: osat, ease
      mode: multi
      options: item {
        label: OSAT
        value: osat
      }, item {
        label: Ease
        value: ease
      }, item {
        label: Recommend
        value: recommend
      }, item {
        label: Renew
        value: renew
      }
    }

    activeColumns: @selcol.selected

    column#osat {
      cell#cell {
        value: average(numeric(:OSAT))
        format: numberStatisticDefaultFormatter
      }
      label: "OSAT"
    }
    row cut #row {
      value: :claimsCenter
    }
    column#ease {
      cell#cell {
        value: average(numeric(:ClaimEase))
        format: numberStatisticDefaultFormatter
      }
      label: "Ease"
    }
    column#recommend {
      cell#cell {
        value: average(numeric(:Recommend))
        format: numberStatisticDefaultFormatter
      }
      label: "Recommend"
    }
    column#renew {
      cell#cell {
        value: average(numeric(:Renew))
        format: numberStatisticDefaultFormatter
      }
      label: "Renew"
    }
  }