Query Summation Report

Query Summation Report

The Query Summation Report may be used in conjunction with DB Queries to determine and evaluate the different attributes associated with the InfoWater Pro data elements (Junctions, Tanks, Reservoirs, Pumps, Valves and Pipes) that satisfy the DB query.

For instance, in the following report, you may evaluate all the attributes of Pipes identified by a query as NEW_PIPES. 

DB Query: 

ID - Specify the ID of the Query that you want to evaluate in your Query Summation Report. 

Summary Field - Choose the Summary Field here. Use this to identify the Summary Class Field values. Depending on the DB Query ID chosen, all the fields corresponding to the DB Query element type will be available.

Summary Class Field - Use this field to select the InfoWater Pro data field summary. The Query Summation Report will display all the selected Summary Class Field values in your Summary Report.

Refresh - Use this to refresh your Query Summation dialog box. Change the Query ID and choose the Summary Field and the Summary Class Field and click on the Refresh button to display the new results.

Close - Use this to close out of the Query Summation dialog box.

Sub ClassThe data field values for the Summary Class Field is listed in this field. For instance, if the Summary Class Field is Diameter, then all the different diameter values will be displayed. 

Sub TotalThe Summary Field value for the Sub Class category is listed in this field. For instance, if the Summary Field is Length, then the total length of elements that have the Sub-Class value is summarized in this field.

Element Count

The number of elements that meet the sub-class characteristic. For instance, in the example report above in row 1 there are a total of 1 pipe with a diameter of 2". 

Contribution (%)

The percent of element count over the total number of elements. For instance, in the example report above in row 1, there is 1 pipe with diameter of 2" and the total number of pipes evaluated is 1955, 1/1955 ~ .05%.

Coverage (%)

The percent of the sub-total value for a sub class over the total value of the sub-class for all elements evaluated. For instance, in the example report above in row 1, there is 222 ft of pipe with a diameter of 2" and the total length of all pipes evaluated is 713,184 ft, 222/713,184 ~ .03.

Query Summation Report - Bar Chart 

For instance, in the following Bar Chart you may evaluate all the attributes of junctions in pressure zone 1 in the form of a bar chart here.

You may choose to customize this graph by using any of the different customization icons available at the top of the bar chart.

Query Bar Graph Modification ButtonsThe following functions are available for customizing the graph display in the Query Summation dialog box. If some of the buttons are grayed out and not clickable while a graph is being displayed, that function is therefore not available for the currently displayed graph type.

Buttons described from left to right.

Navigation Tools: 

Pan 

Zoom In

Zoom Out 

Horizontal Lock 

Vertical Lock 

Previous Extent  

Next Extent 

Full Extent  

Auto Pan Left  

Auto Pan Right

Copy - Copy current view of the graph. Image is stored to the Clipboard. The contents of the clipboard can be pasted into other applications such as MS Word or Excel.

Print - Print the current graph display. The Print dialog box allows you to select a printer.

Properties - Provides properties for more details on this feature.

Graph Help - Provides more detailed help on the InfoWater Pro graphing and customization tools.

Query Summation Report - Pie Chart