load(
  local!pagingInfo: a!pagingInfo(
    startIndex: 1,
    batchSize: -1,
    sort: a!sortInfo(
      field: "dayMonth",
      ascending: true
    )
  ),
  with(
    local!datasubset1: a!queryEntity(
      entity: cons!DATA_STORE_ENTITY,
      query: a!query(
        aggregation: a!queryAggregation(aggregationColumns: {
           a!queryAggregationColumn(field: "month", isGrouping: true()),
          a!queryAggregationColumn(field: "dayMonth", isGrouping: true()),
			    a!queryAggregationColumn(field: "id", aggregationFunction: "COUNT"),
          a!queryAggregationColumn(field: "STATUS", aggregationFunction: "COUNT"),
         }),
        pagingInfo: local!pagingInfo,
         logicalExpression:a!queryLogicalExpression(
          operator:"AND",
          filters:{
            a!queryFilter(
              field:"month",operator:"=",value:"March"
            ),
            a!queryFilter(
              field:"STATUS",operator:"=",value:"SUCCESS"
            )
          }
        )
        )
    ),
    local!datasubset2: a!queryEntity(
      entity: cons!DATA_STORE_ENTITY,
      query: a!query(
        aggregation: a!queryAggregation(aggregationColumns: {
           a!queryAggregationColumn(field: "month", isGrouping: true),
          a!queryAggregationColumn(field: "dayMonth", isGrouping: true()),
			    a!queryAggregationColumn(field: "id", aggregationFunction: "COUNT"),
          a!queryAggregationColumn(field: "STATUS", aggregationFunction: "COUNT"),
         }),
        pagingInfo: local!pagingInfo,
        logicalExpression:a!queryLogicalExpression(
          operator:"AND",
          filters:{
            a!queryFilter(
              field:"month",operator:"=",value:"March"
            ),
            a!queryFilter(
              field:"STATUS",operator:"<>",value:"SUCCESS"
            )
          }
        )
        )
    ),
    a!columnChartField(
      categories: { index(local!datasubset.data, "dayMonth", null)},/*Am facing problem here because both data subsets may not be of same length*/
      series: {
        a!chartSeries(
          label: "Success",
          data: index(local!datasubset1.data,"id", null),
          color:"SKYBLUE"
        ),
        a!chartSeries(
          label: "Failures",
          data: index(local!datasubset2.data, "id", null),
          color:"RED"
        )
      },
      stacking:"NORMAL"
    )
) 
)