How can I add a filter(Countofvehicles>10) for aggregate field for below code?

/*fetch the data group by colour and for each colour how many vechicles
 are there in that record type*/
 
 
a!queryRecordType(
  recordtype:recordType!AA Vehicle,
  fields:a!aggregationFields(
    groupings: {
      a!grouping(
        field:recordType!AA Vehicle.fields.color,
        alias:"color"
      )
    },
    
    measures: {
      a!measure(
        field:'recordType!AA Vehicle.fields.vehicleId',
        function:"COUNT",
        alias:"countofvehicles"
      )
    }
  ),
  pagingInfo: a!pagingInfo(
    startIndex: 1,
    batchSize: 100,
    sort: a!sortInfo(
      field:"countofvehicles"
    )  
  )
)

  Discussion posts and replies are publicly visible

Parents Reply
  • Thanks for giving response  


    above code is for grouping the "color" field and counting how many vehicles per each color. the output like for example 
    color     countofvechiles
    RED       20
    WHITE   10
    BLUE      5
    BLACK   3

    Now , I want to extend that code to add a filter of aggregate filed  "countofvehicles"  like, I want to display only  countofvehicles>5 , not all

Children