Filter use in Column Chart

manjit.1486 said:

userfilter in column chart?

What do you mean by this? AFAIK We have filters on the data. Not sure what you mean by user filters. Could you please elaborate.

For example:


I want to put a dropdown filter option on top of right side. I have already created a userfilter in record. below image will give you a reference(This is just a sample image). In my case: dropdown option would be q1,q2,q3,q4. 

Okay. I will try to do the same.

a!localVariables( 
  local!status: "Q1",
  a!dropdownField(
    label: "Status",
    choiceLabels: {
      "Q1",
      "Q2",
      "Q3",
      "Q4"
    },
    choiceValues: {
      "Q1",
      "Q2",
      "Q3",
      "Q4"
    },
    value: local!status,
    saveInto: local!status,
    placeholder: "Status",
    searchDisplay: "AUTO"
  ),
  a!sectionLayout(
    label: "",
    contents: {      
      a!columnsLayout(
        columns: {
          a!columnLayout(
            contents: {
              a!boxLayout(
                label: "Open Status",
                contents: {
                  a!columnChartField(
                    data: a!recordData(
                      recordType: 'recordType!{6f02251f-0cbb-40a2-881d-0a6bd9983952}INN Status',
                      filters: a!queryLogicalExpression(
                        operator: "AND",
                        filters: {
                          a!queryFilter(
                            field: 'recordType!{6f02251f-0cbb-40a2-881d-0a6bd9983952}INN Status.fields.{status}status',
                            operator: "=",
                            value: "Q1"
                          ),
                        },
                        ignoreFiltersWithEmptyValues: true
                      )
                       
                    ),
                    config: a!columnChartConfig(
                      primaryGrouping: a!grouping(
                        field: 'recordType!{6f02251f-0cbb-40a2-881d-0a6bd9983952}INN Status.fields.{status}status',
                        alias: "status_primaryGrouping"
                      ),
                      secondaryGrouping: a!grouping(
                        field: 'recordType!{6f02251f-0cbb-40a2-881d-0a6bd9983952}INN Status.fields.{stage}stage',
                        alias: "stage_secondaryGrouping"
                      ),
                      measures: {
                        a!measure(
                          function: "COUNT",
                          field: 'recordType!{6f02251f-0cbb-40a2-881d-0a6bd9983952}INN Status.fields.{id}id',
                          alias: "id_count_measure1"
                        )
                      },
                      dataLimit: 100
                    ),
                    label: "",
                    stacking: "NONE",
                    showLegend: true,
                    showDataLabels: true,
                    showTooltips: true,
                    allowDecimalAxisLabels: false,
                    labelPosition: "ABOVE",
                    allowImageDownload: false,
                    colorScheme: a!colorSchemeCustom(
                      colors: {
                        "#00a88f",
                        "#0087ac",
                        "#f7d027",
                        "#6ba547",
                        "#619ed6"
                      }
                    ),
                    height: "MEDIUM",
                    xAxisStyle: "STANDARD",
                    yAxisStyle: "STANDARD",
                    refreshAfter: "RECORD_ACTION"
                  )
                  
                },
                style: "STANDARD",
                marginBelow: "STANDARD"
              )
            },
            width: "8X"
          )
        }
      )
    }
  )
)

Hi.. Can you please guide where do I need to modify the variables?

Did you get a chance to check the code?

Replace the value in the queryFilter of the column chart data parameter with local!status and try.

Not get any luck by doing this.

You need to define your code in a {} as you have array of components post the local variable definition

a!localVariables(
  local!status: "Q1",
  {
    a!dropdownField(
      label: "Status",
      choiceLabels: { "Q1", "Q2", "Q3", "Q4" },
      choiceValues: { "Q1", "Q2", "Q3", "Q4" },
      value: local!status,
      saveInto: local!status,
      placeholder: "Status",
      searchDisplay: "AUTO"
    ),
    a!sectionLayout(
      label: "",
      contents: {
        a!columnsLayout(
          columns: {
            a!columnLayout(
              contents: {
                a!boxLayout(
                  label: "Open Status",
                  contents: {
                    a!columnChartField(
                      data: a!recordData(
                        recordType: 'recordType!{6f02251f-0cbb-40a2-881d-0a6bd9983952}',
                        filters: a!queryLogicalExpression(
                          operator: "AND",
                          filters: {
                            a!queryFilter(
                              field: 'recordType!{6f02251f-0cbb-40a2-881d-0a6bd9983952}.fields.{status}',
                              operator: "=",
                              value: local!status
                            ),

                          },
                          ignoreFiltersWithEmptyValues: true
                        )
                      ),
                      config: a!columnChartConfig(
                        primaryGrouping: a!grouping(
                          field: 'recordType!{6f02251f-0cbb-40a2-881d-0a6bd9983952}.fields.{status}',
                          alias: "status_primaryGrouping"
                        ),
                        secondaryGrouping: a!grouping(
                          field: 'recordType!{6f02251f-0cbb-40a2-881d-0a6bd9983952}.fields.{stage}',
                          alias: "stage_secondaryGrouping"
                        ),
                        measures: {
                          a!measure(
                            function: "COUNT",
                            field: 'recordType!{6f02251f-0cbb-40a2-881d-0a6bd9983952}.fields.{id}',
                            alias: "id_count_measure1"
                          )
                        },
                        dataLimit: 100
                      ),
                      label: "",
                      stacking: "NONE",
                      showLegend: true,
                      showDataLabels: true,
                      showTooltips: true,
                      allowDecimalAxisLabels: false,
                      labelPosition: "ABOVE",
                      allowImageDownload: false,
                      colorScheme: a!colorSchemeCustom(
                        colors: {
                          "#00a88f",
                          "#0087ac",
                          "#f7d027",
                          "#6ba547",
                          "#619ed6"
                        }
                      ),
                      height: "MEDIUM",
                      xAxisStyle: "STANDARD",
                      yAxisStyle: "STANDARD",
                      refreshAfter: "RECORD_ACTION"
                    )
                  },
                  style: "STANDARD",
                  marginBelow: "STANDARD"
                )
              },
              width: "8X"
            )
          }
        )
      }
    )
  }
)

Let me try.

Thank you so much. It worked.

Great! Do verify the answers which were helpful to you.

Sure. :)

Sure. :)