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 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. Click here to learn more about the DB Query creation methodology.

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 data field summary that you want to see. 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 Class
The data field values for the Summary Class Field is listed here. For instance if the Summary Class Field is Diameter then all the different diameter values will be displayed here. 


Sub Total
The Summary Field value for the  Sub Class category is listed here. For instance if the Summary Field is Length then the total length of elements that have the Sub-Class value is summarized here. 


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 ther 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 lengt 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 Buttons
The 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 storedo 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. Print dialog allows for some printing options and selecting printer 

Properties - See Graph Properties for details on thsi feature. 

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


Query Summation Report - Pie Chart