There are a few ways to manipulate views of data grids, and narrow the data selection you are looking at when in the data grid in Professional. Most of the methods and how to work with them are here. 

This section will focus on filtering and grouping. Why? Because these two allow you to create  views of subsets of data based upon criteria. 

Grouping

Grouping does just that: groups data based upon values in the column you chose to group. You can then view just data from that grid of that specific type. Let's say you group by Location Type. You can then open a Location details with only the Location details for a specific group such as Geotechnical Borehole as shown below. This feature is best suited for simple criteria that likely is from a pick list for data entry. You can,. however, group on any field, including depth.

Grouping, does not, however, get in to specifics of depth, such as looking for all sand below 15 feet (or 5 meters). And often times, when on a project, you do need simple queries of data to mix and match, and start to better understand the data across your site. 

Filter

Filters are helpful to ask a little more of your data on any table without getting too in depth or committed to one question. You can quickly filter for something like sand below 15 feet, or N values <5 at depths greater than 15 feet, etc. 

What this means is in a single grid you can use filters in two or more columns to get a little more specific in your search without getting too complex. Of course, it can take a little learning to ask the question correctly and not get back "bad data" but we all learn by trial and error. And this is a quick tool to create and clear queries. You are not commited. You are asking simple engineering questions that may effect your design recommendations and seeing the response. 

Depending on the field type, the filter will be different. For drop down lists, you can select specific list items.

For text and numeric fields you can use selection criteria such as greater than, less than, contains, does not contain, etc. 

In the example above note that "Sandy" is filtered out, but you still get "...with sand" as well as "SAND" in the results. This actually lets you review where all the sand is present, see the descriptions, and get that feel for the site. You can use the filter for USCS to filter out the "GP" or another filter using depth criteria to better understand what is across your site. 

Top Tip: You can use Filter and Grouping on the Project table to narrow down the project list. Items like Client, Contractor, Status, Location, Project Engineer, etc can help you zero in on specifics for a project. The author of this page often uses the Filter to find projects that have number or letter combinations in the project number and/or title. 

What to do Next?

Previous Session

Next Session