Column Chart

Hi manjit.1486  You can use 

Okay, thanks.  Actually only yAxisStyle and xAxisStyle wasn't working before. Rest is working fine.

HI Abhishek Karumuru 
Could you please tell me how to hide or remove this 0 data labels from column chart?


This is basically shows zero records of categories. Please suggest..

Hi Abhishek Karumuru  and Mathieu Drouin can you please suggest?

Hi Abhishek Karumuru  and Mathieu Drouin can you please suggest?

I think you will have to remove these values from the underlying data. It might be possible that you need to query the data separately and feed it into the chart manually.

a!localVariables(
  local!data1:a!queryEntity(
    entity: cons!INN_DSE_CASE,
    query: a!query(
      aggregation: a!queryAggregation(
        {
          {
            a!queryAggregationColumn(field: "status", isGrouping: true()),
            a!queryAggregationColumn(
              field: "stage",
              isGrouping: false,
              aggregationFunction: "COUNT",
              alias: "count"
            ),
          }

        }
      ),
      paginginfo: a!pagingInfo(1, - 1),     
    )
  ),

      a!columnChartField(
        label: "Column Chart",
        categories: {"a","b","c"},
        series: a!forEach(
          items: local!data1,
          expression: a!chartSeries(label: "Chart", data: fv!item.status)
        ),
        stacking: "NONE",
        showLegend: true,
        showTooltips: true,
        labelPosition: "ABOVE",
        colorScheme: "RAINFOREST",
        height: "MEDIUM",
        xAxisStyle: "NONE",
        yAxisStyle: "NONE"
      )
  
)