Explore Analytics continues to add advanced calculation and filtering capabilities to enhance the types of reporting you can deliver for your organization.
Now, you can filter one table based on a query to another table, using the In Lookup or Not In Lookup filters.
The following is an example of In Lookup used in the CMDB Data Quality pre-built report application. This report is a report on the Configuration Item table. The filter is:
- Querying the CI Category Mapping table (where CI classes are mapped to Categories)
- Filtering mapping records where Category IN Business Services and Applications, Infrastructure, Network, or Storage
- Returning the Class values for records that match that filter
- Filtering the Configuration Item table where the Class matches the Class value from the CI Category Mapping table