Analytics Analysis Grid: Filter And/Or Logic

View specific subsets of your data with Filters. When adding more than one filter to your Analysis Grid reports, you must indicate whether the new filter should follow And or Or logic.

And Logic

AND logic requires each data point to meet all filter criteria, narrowing the results. 

For example, if you originally filtered your report to show patients with Medicare as their primary insurance, and now you want to view Medicare patients with a particular diagnosis, you’d add in the diagnosis and leave the filter condition set to And, which would look like this:

Using AND logic in the Filter will shrink the size of the patient pool to meet the additional criteria requested. The filter criteria we used here, tells Analytics to find patients whose insurance type is Medicare AND have a specific diagnosis. 

Or Logic

Or logic only requires a data point to meet one of the filter criteria, increasing the number of results returned.  

For example, if you originally filtered your report to show patients with Medicare as their primary insurance, but now you want to include patients with a particular diagnosis, you’d add in the diagnosis and update the filter condition to Or, which would look like this:

Using OR logic here tells Analytics to find every patient who has a Medicare Primary Insurance type OR has a Shoulder Injury case.

Primary Insurance Type Filter Example

Shoulder Cases Filter Example