Manipulating Data Blocks

Worksheets provide a full complement of sophisticated data manipulation tools, including joins, filters, and concatenations. You will now use some grouping and aggregation tools to manipulate the Data Block that you created earlier in Constructing Data Blocks.

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.

 

 

 

 

 

1. Right-click on the table’s top row and select ‘Group and Aggregate’ from the drop-down menu. This will open the ‘Aggregate’ dialog box.

2. In the ‘Aggregate’ dialog box, make the following selections:

a. For the ‘Order.Date’ field, select the ‘Group’ checkbox and select ‘Month’ from the drop-down list.

b. For the ‘Product.Total’ field, select the ‘Aggregate’ checkbox and choose ‘Sum’ from the drop-down list.

3. Click ‘OK’ to exit the ‘Aggregate’ dialog box. The grouping you specified is applied to the ‘Date’ and ‘Total’ columns of the table. The ‘Category’ column is hidden because no grouping options were specified for it.

Data Worksheet assets can be created and modified both by the desktop Asset Composer, and the webbased Visual Composer.

Saving Data Blocks

After you have created and manipulated a Data Block, you can save this asset to the Asset Repository, where it will be available for use in reports, Viewsheets, and other Worksheets.

1. Click the ‘Save As’ button in the top toolbar to open the ‘Save Worksheet’ dialog.

2. Enter the name “SampleAsset” in the ‘Name’ text box, select ‘Global’ scope, then click ‘OK’.

The asset is saved and appears in the Asset Repository under the ‘Global’ node.

There are many further manipulations you can make to the data in this table. See Manipulating Tabular Data in the Data Worksheet Guide for full details.

Previous: Data Manipulation & Mash-up

Next: Visual Exploration

More Resources:

		Analysis and Reporting for OLAP Cubes
		Data Integration Software
		Structured and Free-form Queries
		Query Traps