Product(s):	WaterGEMS, WaterCAD, SewerGEMS, HAMMER, StormCAD, CivilStorm, SewerCAD
Version(s):	CONNECT Edition, V8i
Area:	Output and Reporting

Problem

Is it possible to add color coding based on multiple conditions / attributes together? 

For example, combinations of "Flow reversal ever occurred" and maximum velocity, or combinations of velocity and pipe diameter.

Solution

When applying color coding to model results, it is applied in a certain order, and currently only one attribute can be color coded on in a given color coding definition. However if there is a need to visualize elements satisfying multiple conditions at a time (for example combinations of if the flow is reversed in pipes and maximum velocity) you can use query-based selection sets to satisfy these conditions by applying multiple color codings in a specific order to get the required result.

Below are sample steps to set up color coding for the condition of: flow reversal ever occurred + maximum velocity < 0.5 m/s, in the same way other criteria’s can be fulfilled using creativity.

1) Using the Queries window, Define a Query on Pipe - Flow Reversed Ever? = True (IdahoFlowDirectionResults_FlowDirectionReversedEver = True)

 

2) Define a Query Based Selection Set based on the query you just defined. 

3) Define 2 color coding’s (see below for details), one for flow reversed pipes and one for pipes where velocity is  < 0.5 m/s based on selection set created earlier. 

Note: Color codings get applied in order (from bottom to top), so be sure they are in the proper order. Use the shift buttons to rearrange things. In the example shown, they are grouped in a folder so they can be turned off together.

This will apply the color coding for these two conditions together, based on the order of color coding created or applied. 

Note : After making any changes to the model or after re-computing the model, if the color coding is not applied correctly, click on refresh button in element symbology, as it happens with query based selection sets. 

Alternative Solutions

1. Use ArcGIS Pro or ArcMap integration and leverage their symbology capabilities.
2. Export model results (using the export button in flextables or with a ModelBuilder connection to an external source such as a spreadsheet), process them in an external application such as Excel, then import or paste them back into a new User Data Extension in the model and color code upon that field. This approach would not be dynamic and would require following the process repeatedly to update values as model data is updated.

See Also

Query based selection sets not updating in various tools such as color coding and annotations