Query regarding Column Chart

Hi

I am working on version 19.1.

I have a query regarding column chart. I have created a column chart. The code for this is:

load(
  local!pagingInfo: a!pagingInfo(
    startIndex: 1,
    batchSize: -1,
    sort: a!sortInfo(
      field: "month",
      ascending: true
    )
  ),
  local!monthSelected,
  local!monthDetails:index(
    a!queryEntity(
      entity: cons!MONTH_DETAILS,
      query: a!query(
        aggregation: a!queryAggregation(aggregationColumns: {
          a!queryAggregationColumn(field: "month", isGrouping: true),
          a!queryAggregationColumn(field: "id", alias: "count", aggregationFunction: "COUNT"),
        }),
        pagingInfo: local!pagingInfo
      )
    ),
    "data",
    {}
   ),
  a!columnChartField(
    categories: index(local!monthDetails, "month", null),
    series: {
      a!chartSeries(
        label: "Months",
        color:"AMBER",
        data: index(local!monthDetails, "id", null),
        links:a!forEach(
          items: local!monthDetails,
          expression: a!dynamicLink(
            value:index(fv!item, "month", null),
            saveInto:{
              local!monthSelected
            }
          )
        )
     )
    },
    xAxisTitle:"Months",
    yAxisTitle:"Population",
    showLegend: false,
    showTooltips: true,
    showDataLabels:true
  )
)

The chart created is:

If you go through the chart created, except 3 months the column for each created for each month is in the range of thousands. For the months Jan, Jun and Sep; the column is not displayed on the chart (I guess because of the range on Y Axis is 10,000 and Appian doesn't display the column for these months) My requirement is, the columns are clickable links. So for these three months i.e. Jan, Jun and Sep; I would like to know how can user click the columns as columns actually don't exist for these three months despite data values being there.

Thanks in advance!!

  Discussion posts and replies are publicly visible