I want to show only top 5 secondary grouping categories for respective month.
{rule!VPA_CMPT_CardDisplayHeader(title: "Most Visited Parking Spot By Month",icon: "parking"),a!columnChartField(data: a!recordData(recordType: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey'),config: a!columnChartConfig(primaryGrouping: a!grouping(field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{2a9520d6-8de2-413f-ad99-7e1ed16d8291}dateCreated',alias: "dateCreated_primaryGrouping",interval: "MONTH_SHORT_TEXT"),secondaryGrouping: a!grouping(field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{08a08942-2bd1-4dc1-902d-6d434e17bbef}parkingLocationName',alias: "parkingLocationName_secondaryGrouping"),measures: {a!measure(function: "DISTINCT_COUNT",field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{628f5a50-0f39-45ca-a0e1-25c645fcb9d3}journeyId',alias: "journeyId_distinct_count_measure1",formatValue: "AUTO")},sort: {a!sortInfo(field: "dateCreated_primaryGrouping",ascending: false),a!sortInfo(field: "journeyId_distinct_count_measure1")}),label: "",stacking: "NORMAL",showLegend: false,showDataLabels: true,showTooltips: false,labelPosition: "ABOVE",colorScheme: a!colorSchemeCustom(colors: {cons!VPA_HEX_COLOR_1,"#323b81","#c27ba0","#93c47d","#8e7cc3","#ffd966"}),height: "MEDIUM",xAxisStyle: "STANDARD",yAxisStyle: "STANDARD",refreshAfter: "RECORD_ACTION")}
Discussion posts and replies are publicly visible