InetSoft Technology: Dashboard Software - Dashboard Data Parameters

InetSoft's award-winning dashboard software allows users to set specific dashboard data parameters that will filter or set complex dynamic data sets autonomously. View the example below to learn more about the Style Intelligence solution.

You can use a variable or parameter as the test value in a filter condition. The user of the Worksheet (including users of linked Viewsheets and reports) will be prompted at runtime to enter the value of the parameter.

To use a variable or parameter in a filter condition, follow these steps:

1. Open the Worksheet containing the table you want to filter.

2. (Optional) To use a variable in the condition, first create the Variable, or drag an existing Variable from the asset tree to an empty cell in the Worksheet.

3. Click the 'Condition' button on the title bar of the table you wish to filter. This opens the 'Condition' dialog box.

4. Open the edit field in either the 'Simple Condition' mode (click the 'More' button) or 'Advanced Condition' mode (click the pre-aggregate or post-aggregate 'Edit' button).

5. Select 'Variable' from the rightmost popup menu. This opens a blank Combo Box on the right side of the condition.

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.

 

 

 

 

6. In the Combo Box, do one of the following:

a. Select an existing Variable from the menu, or; b. Type the name of a new parameter

7. Define the rest of the condition as described earlier.

The user is prompted for Variables and parameters in the same manner. However, Variables provide additional control over the interface (radio button, menu, etc.) and the set of choices presented to the user.

You can use table values as the test values in a filter condition. That is, you can define a filter condition that compares two values in the same row of the table.

To use a table field in a filter condition, follow these steps:

1. Open the Worksheet containing the table you want to filter.

2. Click the 'Condition' button on the title bar of the table you wish to filter. This opens the 'Condition' dialog box.

3. Open the edit field in either the 'Simple Condition' mode (click the 'More' button) or 'Advanced Condition' mode (click the pre-aggregate or post-aggregate 'Edit' button).

4. Make the desired selections in the left three menus.

5. Select 'Field' from the right-most menu. This enables a Combo Box on the right side of the condition.

6. In the Combo Box, select the table column containing the values to test.

The condition compares corresponding values in the selected columns (left-most menu and right-most menu), and preserves only rows where the condition is met.

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

 

Previous: Filtering Dashboard Operators

Next: Multiple Database Dashboard

 

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