Most Visited Parking Spot By Month

Certified Senior Developer

Not able to fetch the top 3 most visited spots for a repective month with below mentioned code.

Kinldy suggest

{
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