Skip to main content
manjit.1486
April 24, 2024
Solved

Filter use in Column Chart

  • April 24, 2024
  • 16 replies
  • 0 views

Hello everyone,

Can anyone suggest how we can use userfilter in column chart? I am fetching data from records in column chart. However, filter is not working. Please suggest.

Thanks

Best answer by konduruc733182

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"
            )
          }
        )
      }
    )
  }
)

16 replies

konduruc733182
April 24, 2024
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.

manjit.1486
April 24, 2024

For example:


konduruc733182
April 24, 2024

You cannot have userFilter to filter the Column chart. Have a custom dropDown which filters your data.