Pie Chart

Here is the full code for your reference.

a!queryEntity(
  entity: /* PASS YOUR DATASTORE ENTITY CONSTANT*/,
  query: a!query(
    aggregation: a!queryAggregation(
      aggregationColumns: {
        a!queryAggregationColumn(
          field: "Surveyid",
          isGrouping: true
        ),
        a!queryAggregationColumn(
          field: "id",
          aggregationFunction: "COUNT"
        )
      }
    ),
    logicalExpression: a!queryLogicalExpression(
      operator: "AND",
      filters: {
        a!queryFilter(
          field: "startDate",
          operator: ">=",
          value: ri!backDate
        ),
        a!queryFilter(
          field: "startDate",
          operator: "<=",
          value: ri!date
        )
      }
    ),
    pagingInfo: a!pagingInfo(
      1,
      - 1
    )
  )
).data