InetSoft's Dashboard Worksheet Options

InetSoft's dashboard software provides users with extensive data worksheet options allowing for the highest level of report customization imaginable. These options allow a dashboard designer to choose which data to work with, perform data transformations and pre-filtering, and preview live data of his query before moving on to dashboard layout. View the documentation example below to learn more about the Style Intelligence solution.

When you save a Worksheet, all of its constituent assets (Data Tables, Named Groups, Variables, etc.) are saved together. However, only the asset marked as “Primary” is accessible to reports and other Worksheets.

The asset marked “Primary” determines the appearance of the Worksheet icon in the Asset Repository.

To close a Worksheet, do one of the following:

• Press Ctrl-W on the keyboard.

• Click the 'X' in the Worksheet tab at the bottom of the screen.

If the Worksheet contains unsaved changes, you will be prompted to save the Worksheet.

#1 Ranking: Read how InetSoft was rated #1 for user adoption in G2's user survey-based index Read More

To set global Worksheet options, click the 'Options' button in the Worksheet toolbar. There are three global options available:

• 'As data source to reports' specifies that the Worksheet is accessible for data binding in reports, as well as for use by Viewsheets.

• 'Alias' specifies a designation to be used in place of the actual Worksheet name. The alias replaces the

Worksheet name in all contexts except the following: The left-side 'Data' panel of the desktop Asset Composer, the Objects tab in Enterprise Manager, and the 'Export Assets' page in Enterprise Manager. These always display the actual Worksheet name.

• 'Design mode sample data size' globally limits the number of rows returned by any query or subquery forLive Data mode.

why select InetSoft
“Flexible product with great training and support. The product has been very useful for quickly creating dashboards and data views. Support and training has always been available to us and quick to respond.
- George R, Information Technology Specialist at Sonepar USA

If a table in the Worksheet is composed from multiple sub-queries, each individual subquery result will be capped at the specified 'Design mode sample data size' maximum. This may prove efficient when the final table is itself row-limited.

For example, if the final table displays only 20 rows in Live Data mode, it may be unnecessary for the component sub-queries to each retrieve thousands of rows, and restricting these query result sets may be desirable. However, artificially limiting queries in this way can also yield an unrepresentative Live Data result in some cases.

Previous: Editing Dashboard Worksheets