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 Dashboard Software can do.

 

 

 

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.

 

Evaluate InetSoft's Business Intelligence Software for your dashboard and reporting software needs.

 

Previous: Filtering Dashboard Data

Next: Filtering Dashboard Operators

 

Related Links:

		Style Scope
		Dashboards for Every Industry

More Resources:

		Download a Free Trial
		Java Dashboard Software
		BI Dashboards for Salesforce.com Users
		OLAP Reporting and Dashboard Tool