load(
  local!pagingInfo: a!pagingInfo(
    startIndex: 1,
    batchSize: -1,
    sort: a!sortInfo(
      field: "createdDate",
      ascending: true
    )
  ),
  with(
    local!datasubset: a!queryEntity(
      entity: cons!DATA_STORE_ENTITY,
      query: a!query(
        aggregation: a!queryAggregation(aggregationColumns: {
          a!queryAggregationColumn(field: "dayMonth", isGrouping: true()),
			a!queryAggregationColumn(field: "id", aggregationFunction: "COUNT"),
          a!queryAggregationColumn(field: "STATUS", aggregationFunction: "COUNT"),
         }),
        pagingInfo: local!pagingInfo,
         filters:{
            a!queryFilter(field:"month", operator:"=", value:"")
          }
        )
    ),
    a!columnChartField(
      categories: { index(local!datasubset.data, "dayMonth", null)
      },
      series: {
        a!chartSeries(
          label: "Success",
          data: index(local!datasubset.data,wherecontains({"Initiate Demand"},toString(local!datasubset.data.STATUS)), null),
          color:"SKYBLUE"
        ),
        a!chartSeries(
          label: "Failures",
          data: index(local!datasubset.data, where(local!datasubset.data,tostring(local!datasubset.data.STATUS)<>"STATUS"), null),
          color:"RED"
        )
      },
      stacking:"NORMAL"
    )
) 
)