Inetsoft Product Information: Dashboard Software - Aggregating Dashboard Data

Users can easily aggregate data and create comprehensive reports from different data sources using InetSoft's award-winning dashboard software. View the example below to learn more about the Style Intelligence solution.

To define grouping and aggregation columns (summary columns) for a Data table, follow these steps:

1. Right-click the table's title row and select 'Group and Aggregate'. This opens the 'Aggregate' dialog box.

2. Select the grouping columns by clicking the 'Group' check box next to one or more column names.

When you enable grouping for a column, by default each distinct value in the column defines its own group. Aggregation is then based on these groups. For example, if you group a column of state names, each distinct state name will define its own group, and aggregate val­ues will be computed for each of those groups.

3. (Optional) If a user-defined group matches the grouping column data format (String, Double, etc.), you can select the user-defined group from the right-side menu.

User-defined groups give you greater flexibility in partitioning the entries in a column for grouping. If you select a user-defined grouping from the menu, aggregations will be based on that user-defined grouping.

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.

 

 

 

 

 

4. (Optional) If you specify grouping for a column that has a Date format, you can select a predefined or user-defined Date grouping (Year, Quarter, etc.) from the right-side menu.

The actual date values in the grouping column will be replaced with the new group labels, e.g., '1st Quarter', 'January', etc.

5. Click the 'Aggregate' check box for columns containing the measures that you wish to aggregate (summarize).

6. For the aggregate columns, choose the method of aggregation (Sum, Correlation, etc.).

7. (Optional) For the univariate aggregation methods (Sum, Max, etc.), select the 'Percentage' check box to display the aggregated measure as a percentage of the grand total.

8. (Optional) For the bivariate aggregation methods (Correlation, etc.), select the second operand (column) for the computation from the 'with' menu.

9. Click 'OK' to close the 'Aggregate' dialog box.

The table is now grouped. Only the table columns that are either grouping columns or aggregate columns are shown in the grouped table. All other columns are hidden. In the grouped table, each column has an icon indicating whether it is a grouping column or an aggregate column. Click any of these icons to reopen the 'Aggregate' dialog box.

Previous: Subquery Dashboard Options

Next: Dashboard Crosstab Table

InetSoft Viewpoint

"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. So organizations are now moving towards standardization of BI platforms and looking for a platform not just for the business intelligence needs but also to integrate it with business processes capabilities integrated with applications from multiple vendors and technologies such as search. That kind of standardization on one BI platform, it definitely helps to drive efficiency. The other area is to have service level agreements with the business, an information foundation where information is extracted via service oriented Web services, enterprise services, with guaranteed service level agreements such as response times. That is an area that we have been heavily investing in together with business partners to leverage in-memory technology to deliver rapid response time independent of any type of query or business request. It certainly helps with agility." - Luke Liang, CEO, InetSoft

 

 

 

 

 

 

 

 

 

 

 

 

 

 

More Resources:

		Creating a Dashboard Crosstab Table
		BI Dashboard Software Features
		The Best Dashboard and Scorecard Software
		Dashboard Software Vendors: InetSoft Technology