InetSoft's dashboard software offers an embeddable dashboard table that facilitates the creation of interactive multidimensional reporting. View the example below to learn more about the Style Intelligence solution.
Instead of creating a regular table from a query or data model, you can create a Data Table by manually typing values into the Worksheet. Such a table is called an Embedded Table. There are two ways to generate an embedded table:
• Create a new embedded table using the 'Embedded Table' option in the 'New Object' menu.
• Convert a regular Data Table into an embedded table.
After you generate an embedded table, you can use it in the same way as a regular Data Table. Embedded tables also provide a means for Viewsheets to filter the data returned by Worksheet queries, enabling straightforward what-if analysis. To create a new embedded table, follow these steps:
1. Click the 'New Object' button, and select 'Embedded Table'. The cursor changes to a cross.
2. Click and drag the cursor across the cells that you want to compose the table. The cells are highlighted as you drag across them.
When you release the cursor, the highlighted cells are converted into an embedded table. The top row of cells becomes the title row of the table, the second-to-top row becomes the column header row of the table, and any remaining rows of highlighted cells become the data rows of the table.
3. To edit a column header, double-click on the header and enter the desired text.
4. To edit a data cell, click in the cell and enter text directly. You can enter both numeric and non-numeric values.
Assume that you want to create a table of values to be used in a formula for some other table on the Worksheet. In the following example you will create an embedded table with three rows and three columns of data.
1. Create a new Worksheet by clicking on the 'New Worksheet' button.
2. Click on the 'New Object' button, and select the 'Embedded Table' option. The cursor changes to a cross.
3. Drag across the Worksheet to highlight five rows and three columns. When you release the mouse, the selected range of the empty grid cells becomes part of the new table called 'Query1'; the first row of the selected range becomes the header row, and the second row becomes the column header row.
4. All the cells of this newly created table are editable. Double-click on the 'col0' header cell. The cell switches to editing mode, and you can now type in the cell to change the text.
5. Change the column names for 'col0', 'col1' and 'col2' to 'A', 'B' and 'C', respectively.
6. Enter any numeric values in the nine data cells. Note that both numeric and non-numeric values can be entered in the table.
InetSoft Technology Corp.
InetSoft Technology Corp.