Skip to content
  • There are no suggestions because the search field is empty.

Combining Management Zone High/Low Checks into Main Zones

When high and low checks are creating clutter in your visuals, follow these steps to roll up the checks into the main zone data.

In order to combine data for multiple text strings, you will need to create a new Field and input a formula that looks at the original data and replaces some components with what you desire.  Here is an example for how to combine all of the High and Low checks for Management Zones into their respective zones (vs. just filtering that data out):

  1.  Choose the plus button next to fields to add a Calculated Field:

  1.  Input this syntax into the formula box and name your new field as desired:

Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace([Mgmt Zone],"A Zone High Check", "A Zone"),"A Zone Low Check", "A Zone"),"B Zone High Check", "B Zone"),"B Zone Low Check", "B Zone"),"C Zone High Check", "C Zone"),"C Zone Low Check", "C Zone"),"D Zone High Check", "D Zone"),"D Zone Low Check", "D Zone"),"E Zone High Check", "E Zone"),"E Zone Low Check", "E Zone"),"F Zone High Check", "F Zone"),"F Zone Low Check", "F Zone")