Problem

The following procedure demonstrates how to use the General Aggregation Report plugin to run a Percentiles Aggregation on data in your Predix Studio Index.

When applied on the sample data set, it shows the number of distinct values in the total passing vehicle volume field.

Dependencies

• Ingest data into DMW following these instructions and using this sample data set. Name your model com.ged_chicagotraffic and your package ChicagoTraffic.

• Use the Director Service Debugger with the General Aggregations Plugin.

.

Steps

1) Navigate to director service debugger.

2) Open GeneralAggregations.xml.

3) Select POST as the query type.

4) Input the following query into the Content field, making sure to adjust the value in Index to reflect your index name.

   <Index>com.ged_chicagotraffic</Index>
     <Type>ChicagoTraffic</Type>
       <AggNode name="Passing Vehicles" type="cardinality">
         <Field>chicagoTraffic_totalPassingVehicleVolume</Field>
       </AggNode>

In the Result field, you should see something that looks like this.

   <Report>
     <Aggregation name="Passing Vehicles">
       <Entry key="cardinality">398</Entry>
     </Aggregation>
   </Report>

Other Resources

• Cardinality Aggregation