InetSoft Product How-To: Embedded Dashboard Commands

The embedded dashboard commands available in InetSoft's award-winning dashboard software application allow for the highest level of customization available on the market. View the example below to learn more about the Style Intelligence solution.

To add a new row to an embedded table, follow these steps:

1. Deselect the table. (Click the Viewsheet grid away from the table.)

2. Right-click a table row, and choose 'Insert Row' from the context menu. This inserts a blank row above the row you clicked.

To remove an existing row from an embedded table, follow these steps:

1. Deselect the table. (Click the Viewsheet grid away from the table.)

2. Right-click on the table row you want to delete, and choose 'Remove Row' from the context menu. This removes the row you clicked, and shifts subsequent rows upward in the table.

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

An expression column, or formula column, is a column whose data is generated from a script (expression) by processing existing data in the table. The expression can use either SQL or JavaScript syntax, and can reference any other columns within the Data Table. To add an expression column to a table, follow these steps:

1. Click the 'Expression' button (labeled 'fx') located in the title row of the Data Table. This opens the 'Expression' dialog box.

2. Enter a name for the new column in the dialog box, and click 'OK'. This adds the formula column to the right side of the table, and opens the Formula Editor.

3. In the Formula Editor, click the 'SQL' box to toggle between SQL and JavaScript syntax and select the appropriate data type from the 'Return Data Type' menu.

4. Enter the desired formula expression in the bottom text field. (JavaScript expression columns can make full use of the built-in scripting functions in the script library.)

5. Click 'OK' to exit the Formula Editor. The data in the new column will reflect the results of the specified expression.

Previous: Embedded Dashboard Options