Solved
Filter use in Column Chart
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
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
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"
)
}
)
}
)
}
)Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.