Report Filtering Example

InetSoft's reporting software features report filtering that allows you to set the conditions you need to get the most out of your data reports. View the example below to learn more about the Style Intelligence solution.

When you customize a report to your requirements, you will often set conditions to select datasets of interest. If you have a report of expenses in your organization and wish to know only about those whose value is greater than or equal to $10,000, you will need specify this requirement as a filter condition on your element.

In this example, we will discuss some of the basic options available using filtering as well as some advanced features. Open the ‘Ad Hoc’ report. Right-click on a table and choose ‘Filtering’. Multiple conditions can be added by using ‘AND’ or ‘OR’ logical operators.

information dashboard design software

#1 Ranking: Read how InetSoft was rated #1 for user adoption in G2's user survey-based index Read More

machine learning reporting example

Table 2. List of Comparison Operators.

equal to It equates two entities.
one of Checks if the value is a member of a list.
less than Less than numerically, earlier date, etc.
greater than Greater than numerically, later date, etc.
between Checks if the value is in a range.
starting with Checks the beginning of a string.
contains Checks if the value contains a substring.
null Checks if the value is null.

InetSoft Viewpoint

“So based on this BI platform, our software delivers a host of front-end BI tools including visualization tools, enterprise reporting, monitoring dashboards, and analysis. Those functions were based on a very powerful patent-pending technology we call Data Block. This Data Block technology is really made up of a back-end data mashup engine and a caching middle layer. There is a front-end we call the worksheet, which is a Web-based, spreadsheet-like user interface that a power user can easily use to combine and transform data blocks.

The data blocks are typically started at the atomic data block level. That is typically created by an IT or a BI specialist. They choose these data blocks and performance tune those data blocks. Then the power users can use those building blocks to build more complex, but more useful structures for answering the questions they have on hand.And all the data blocks you build, in turn become building blocks themselves. You can build on this architecture, building very sophisticated structures which you can use to answer a wide range of unanticipatible questions.

Read the top 10 reasons for selecting InetSoft as your BI partner.

The real-time access to the data is what this architecture delivers for you. It allows you to access different data sources regardless of whether it’s an operational data store or a data warehouse. It basically gives a means to the domain expert to shape the data on demand for whatever they need. And so we are very excited about this BI technology that we have had for years. We have been showing this in the beta phase, and recently it has come into production mode. And we have already gotten very good feedback on the technology from customers.” - Luke Liang, CEO

Previous: Report Column Features