InetSoft Product Information: Dashboard Software - Advanced Dashboard Filtering

Using InetSoft's award-winning dashboard software, users can unite complex and disparate data formats into one cohesive report by performing advanced dashboard data filtering. View the example below to learn more about the Style Intelligence solution.

To specify conditions on both pre-aggregate and post-aggregate data, as well as group rankings, use the 'Advanced Conditions' dialog box. Advanced conditions can additionally be joined using both 'AND' and 'OR' operations. If you only need pre-aggregate conditions and 'AND' operations, you can use simple conditions instead.

To define advanced conditions, follow these steps:
1. Click the 'Condition' button on the title bar of a Data Table. This opens the 'Condition' dialog box.

2. Select the 'Advanced Conditions' check box.

The 'Advanced Conditions' check box can be used to toggle between simple and advanced conditions. However, when switching from the 'Advanced conditions' mode to the 'Simple Conditions' mode, if an advanced condition cannot be mapped to a simple condition, it will be permanently removed from the list of conditions.

3. Define a condition on pre-aggregate data, post-aggregate data, or ranking by clicking on the corresponding 'Edit' button.

View a five-minute Flash demo to get an overview of what InetSoft's business intelligence software, Style Intelligence, can do and how easy it is to use.

 

 

 

 

 

If the condition you specify references attributes that do not already exist in the table, these attributes are automatically added to the table as invisible columns.

Pre-aggregate conditions are applied to the detail rows of the table, whereas post-aggregate conditions are applied to the data in the summary rows of the table. (Pre-aggregate conditions are equivalent to conditions defined in the 'Where' clause of the SQL statement, and post-aggregate conditions are equivalent to conditions specified in the 'Having' clause of the SQL statement.) Ranking conditions specify the Top N or Bottom N number of rows that should be presented in the table.

Previous: Filtering Dashboard Data

Next: Filtering Dashboard Operators

InetSoft Viewpoint

"BPM is just a natural fit into that, where that data, those business intelligence dashboards, are feeding into something that at the point in time, as someone mentioned earlier, that is where they need the information the most. That is where the natural synergy comes in. So it just depends how complex the organization data needs are, the information needs are, how they want it structure it. Do they want to put a process infrastructure strategy in place and then from that process see the key points where the business intelligence infrastructure can naturally feed into it, or are they already getting the information, and now they need to put it into a context which is where BPM comes in. It's true that driving business intelligence and collaboration and also drives business intelligence best practices. Let me explain how you do that with our BI solution. One area that we see is a focus on standardization of the BI platform. If you look at how traditionally BI has been deployed across organizations, it was of a mix of different BI tools and technologies which were driven by individual business demands, but often lacking overall a cohesive information strategy. The challenge of this kind of business intelligence strategy was it was very hard to maintain and adapt to changing business needs. Many resources went into just managing this complex BI infrastructure." - Luke Liang, CEO, InetSoft

 

 

 

 

 

 

 

 

 

 

 

 

 

More Resources:

		InetSoft's Interactive 2011 Green Car Dashboard
		Details about InetSoft's Java Dashboard Software
		Better BI Dashboards for Salesforce.com Users
		An OLAP Reporting and Dashboard Tool