load(
  local!pagingInfo: a!pagingInfo(
    startIndex: 1,
    batchSize: -1,
    sort: a!sortInfo(
      field: "worksubtypename",
      ascending: true
    )
  ),
  with(
    local!datasubset: a!queryEntity(
      entity: cons!RPT_PROCESSDATASERIESVIEW_ENTITY,
      query: a!query(
        aggregation: a!queryAggregation(aggregationColumns: {
          a!queryAggregationColumn(field: "worksubtypename", isGrouping: true),
          a!queryAggregationColumn(field: "slablack", aggregationFunction: "SUM"),
          a!queryAggregationColumn(field: "slared", aggregationFunction: "SUM"),
          a!queryAggregationColumn(field: "slaamber", aggregationFunction: "SUM"),
          a!queryAggregationColumn(field: "slagreen", aggregationFunction: "SUM"),
          a!queryAggregationColumn(field: "slanull", aggregationFunction: "SUM"),
          a!queryAggregationColumn(field: "olablack", aggregationFunction: "SUM"),
          a!queryAggregationColumn(field: "olared", aggregationFunction: "SUM"),
          a!queryAggregationColumn(field: "olaamber", aggregationFunction: "SUM"),
          a!queryAggregationColumn(field: "olagreen", aggregationFunction: "SUM"),
          a!queryAggregationColumn(field: "olanull", aggregationFunction: "SUM"),
          a!queryAggregationColumn(field: "diarised", aggregationFunction: "SUM"),
          a!queryAggregationColumn(field: "pending", aggregationFunction: "SUM"),
          a!queryAggregationColumn(field: "processing", aggregationFunction: "SUM"),
          a!queryAggregationColumn(field: "processid", alias: "Total", aggregationFunction: "COUNT")
        }),
        pagingInfo: local!pagingInfo,
        logicalExpression: a!queryLogicalExpression(
          operator: "AND",
          filters: {  
        	  a!queryFilter(
        	    field: "isactive",
        	    operator: "=",
        	    value: true
        	  ),
        	  a!queryFilter(
        	    field: "department",
        	    operator: "=",
        	    value: "Primary Servicing"
        	  )
          }
        )
      )
    ),
    {
      a!barChartField(
        label: "Outstanding Work By SLA & Work Sub-Type",
        labelPosition: "ABOVE",
        categories: {
          index(local!datasubset.data, "worksubtypename", null)
        },
        series: {
          a!chartSeries(Label: "Black", data: index(local!datasubset.data, "slablack", null), color: "PURPLE"),
          a!chartSeries(Label: "Red", data: index(local!datasubset.data, "slared", null), color: "RED"),
          a!chartSeries(Label: "Amber", data: index(local!datasubset.data, "slaamber", null), color: "ORANGE"),
          a!chartSeries(Label: "Green",  data: index(local!datasubset.data, "slagreen", null), color: "GREEN"),
          a!chartSeries(Label: "N/A", data: index(local!datasubset.data, "slanull", null), color: "GOLD")
        },
        stacking:"NORMAL"
      ),
      a!gridField(
        label: "Outstanding Work By SLA & Work Sub-Type",
        totalCount: local!datasubset.totalCount,
        columns: {
          a!gridTextColumn(
            label: "Work Sub-Type",
            field: "worksubtypename",
            data: index(local!datasubset.data, "worksubtypename", {}),
            alignment: "LEFT"
          ),
          a!gridTextColumn(
            label: "Black",
            field: "slablack",
            data: index(local!datasubset.data, "slablack", {}),
            alignment: "RIGHT"
          ),
          a!gridTextColumn(
            label: "Red",
            field: "slared",
            data: index(local!datasubset.data, "slared", {}),
            alignment: "RIGHT"
          ),
          a!gridTextColumn(
            label: "Amber",
            field: "slaamber",
            data: index(local!datasubset.data, "slaamber", {}),
            alignment: "RIGHT"
          ),
          a!gridTextColumn(
            label: "Green",
            field: "slagreen",
            data: index(local!datasubset.data, "slagreen", {}),
            alignment: "RIGHT"
          ),
          a!gridTextColumn(
            label: "N/A",
            field: "slanull",
            data: index(local!datasubset.data, "slanull", {}),
            alignment: "RIGHT"
          ),
          a!gridTextColumn(
            label: "Total",
            field: "Total",
            data: index(local!datasubset.data, "Total", {}),
            alignment: "RIGHT"
          )
        },
        value: local!pagingInfo,
        saveInto: local!pagingInfo
      ),
      a!barChartField(
        label: "Outstanding Work By OLA & Work Sub-Type",
        labelPosition: "ABOVE",
        categories: {
          index(local!datasubset.data, "worksubtypename", null)
        },
        series: {
          a!chartSeries(Label: "Black", data: index(local!datasubset.data, "olablack", null), color: "PURPLE"),
          a!chartSeries(Label: "Red", data: index(local!datasubset.data, "olared", null), color: "RED"),
          a!chartSeries(Label: "Amber", data: index(local!datasubset.data, "olaamber", null), color: "ORANGE"),
          a!chartSeries(Label: "Green",  data: index(local!datasubset.data, "olagreen", null), color: "GREEN"),
          a!chartSeries(Label: "N/A", data: index(local!datasubset.data, "olanull", null), color: "GOLD")
        },
        stacking:"NORMAL"
      ),
      a!gridField(
        label: "Outstanding Work By OLA & Work Sub-Type",
        totalCount: local!datasubset.totalCount,
        columns: {
          a!gridTextColumn(
            label: "Work Sub-Type",
            field: "worksubtypename",
            data: index(local!datasubset.data, "worksubtypename", {}),
            alignment: "LEFT"
          ),
          a!gridTextColumn(
            label: "Black",
            field: "olablack",
            data: index(local!datasubset.data, "olablack", {}),
            alignment: "RIGHT"
          ),
          a!gridTextColumn(
            label: "Red",
            field: "olared",
            data: index(local!datasubset.data, "olared", {}),
            alignment: "RIGHT"
          ),
          a!gridTextColumn(
            label: "Amber",
            field: "olaamber",
            data: index(local!datasubset.data, "olaamber", {}),
            alignment: "RIGHT"
          ),
          a!gridTextColumn(
            label: "Green",
            field: "olagreen",
            data: index(local!datasubset.data, "olagreen", {}),
            alignment: "RIGHT"
          ),
          a!gridTextColumn(
            label: "N/A",
            field: "olanull",
            data: index(local!datasubset.data, "olanull", {}),
            alignment: "RIGHT"
          ),
          a!gridTextColumn(
            label: "Total",
            field: "Total",
            data: index(local!datasubset.data, "Total", {}),
            alignment: "RIGHT"
          )
        },
        value: local!pagingInfo,
        saveInto: local!pagingInfo
      ),
      a!barChartField(
        label: "Outstanding Work By Status & Work Sub-Type",
        labelPosition: "ABOVE",
        categories: {
          index(local!datasubset.data, "worksubtypename", null)
        },
        series: {
          a!chartSeries(Label: "Pending", data: index(local!datasubset.data, "pending", null), color: "BLUEGRAY"),
          a!chartSeries(Label: "Processing", data: index(local!datasubset.data, "processing", null), color: "LIMEGREEN"),
          a!chartSeries(Label: "Diarised", data: index(local!datasubset.data, "diarised", null), color: "GOLD")
        },
        stacking:"NORMAL"
      ),
      a!gridField(
        label: "Outstanding Work By Status & Work Sub-Type",
        totalCount: local!datasubset.totalCount,
        columns: {
          a!gridTextColumn(
            label: "Work Sub-Type",
            field: "worksubtypename",
            data: index(local!datasubset.data, "worksubtypename", {}),
            alignment: "LEFT"
          ),
          a!gridTextColumn(
            label: "Pending",
            field: "pending",
            data: index(local!datasubset.data, "pending", {}),
            alignment: "RIGHT"
          ),
          a!gridTextColumn(
            label: "Processing",
            field: "processing",
            data: index(local!datasubset.data, "processing", {}),
            alignment: "RIGHT"
          ),
          a!gridTextColumn(
            label: "Diarised",
            field: "diarised",
            data: index(local!datasubset.data, "diarised", {}),
            alignment: "RIGHT"
          ),
          a!gridTextColumn(
            label: "Total",
            field: "Total",
            data: index(local!datasubset.data, "Total", {}),
            alignment: "RIGHT"
          )
        },
        value: local!pagingInfo,
        saveInto: local!pagingInfo
      )
    }
  )
)