AQS statistics data source

Item statistics returned by an AQS query

An AQS statistics data source represents the results of an AQS query that returns statistical data about qualifying items of a particular design/interface.

Depending on the query, the result may be a single number value, or multiple numbers (if grouping is applied). To learn more, see AQS Statistics root node.

Create an AQS statistics data source

To create an AQS statistics data source in the Report Builder:

1. Open the Data sources tab and select Create data source.

   

2. Supply a distinct Name. Users see this when running the report, so make sure it describes the data source clearly. To ensure the data source is always populated when running the report, enable Required.

3. Select Type and choose AQS statistics aggregation.

4. Consider setting an appropriate default query if possible. This safeguards your report against possible failure. Users can still change the value when running the report. Select Default AQS statistics query to open the AQS Builder.

5. Select Create to finish.

   

Customise sorting and headers

To configure these optional fields, edit the data source after creating it:

• Sorting - specify how the data should be sorted. See Data source sorting.

• Headers - retitle selected headers for easier identification. See Data source headers.

Use another data source as a query parameter

It's possible to use another data source in the report as a parameter when setting the Default AQS statistics query.

For example, you want an AQS statistics data source that counts all items of the Street Lights design within a user-supplied area.

To do this:

1. Create a constant data source and set the Type appropriately, e.g. Geometry.

2. When creating your AQS statistics data source, select Default AQS statistics query to show the AQS Builder.

3. In the purple Parameters box, select .

   

4. Select Data source headers, select beside your constant data source, and then select the Value header.

   

5. Set the Display name and Default value as needed. Select Save.

   

6. Use the parameter when building your query.