Creating and Modifying Dashboards

Introduction to the Autosave FeatureCopy link to this section

The system provides an optional autosave feature, which can automatically save the state of the User Portal for each user, for each dashboard. If the autosave feature is enabled for the User Portal:

• When you access the User Portal, the system displays that user interface as you last saw it.

• When you display a dashboard, the system displays that dashboard as you last saw it.

For information on this option, see “Specifying Basic Settings” in Implementing InterSystems Business Intelligence. Note that there is a separate autosave feature for the Analyzer.

Creating a DashboardCopy link to this section

To create a dashboard, use the following overall process:

1. Log in to the User Portal in the desired namespace, as described earlier.

2. Click Menu > New Dashboard.

   Or click the Add button , which is above the list of dashboards, as follows:

   

   Then click Add Dashboard.

   Or click the < button at the left side of the User Portal, click Add, and then click Add Dashboard.

   In any case, the system then displays a dialog box that prompts you for basic information about the new dashboard.

3. For Folder, optionally type a folder name or select an existing folder.

   Also see “Preparing for Folder Item Localization” in Implementing InterSystems Business Intelligence.

4. For Dashboard Name, type the name of the dashboard.

   Also see “Preparing for Folder Item Localization” in Implementing InterSystems Business Intelligence.

   Note that this name is used (along with Folder) as the logical name of the dashboard; the system displays this logical name when you use the Save As option, for example.

5. Optionally provide values for the other options as given in the next section.

6. Click OK.

   The system creates, saves, and displays the dashboard, which is initially empty.

7. To configure the dashboard, use a combination of the following tools:

   • The Dashboard Editor. For an introduction, see “Modifying Dashboard Settings,” later in this chapter.

   • The Menu. For an introduction, see “Adding a Widget to a Dashboard,” later in this chapter.

Modifying Dashboard SettingsCopy link to this section

To modify settings of a dashboard or of the widgets in a dashboard:

1. Display the dashboard as described in “Accessing Business Intelligence Dashboards,” earlier in this book.

2. Click the > button to the left of the dashboard. (If this button is not visible, either the dashboard is not editable or you do not have permission to edit it.) The following shows an example:

   

   The system then expands the Dashboard Editor as follows:

   

   To hide the Dashboard Editor, click the < button.

3. Click Dashboard Settings.

4. Specify any of the following options as needed:

   • Locked — Select this option to temporarily prevent changes to this dashboard. If you select this option, you cannot edit the dashboard again unless you first clear the Locked option again.

   • Public — Select this option to control whether this dashboard is displayed in the User Portal main area.

     Important:

     This option does not control access to the dashboard. Access is controlled instead by the Owner and Resource options, discussed later in this list.

     Note that even if the dashboard is not marked as public, you can access it via Main > Open. Also, you can find it in the User Portal by using the Find option. See the Using Dashboards and the User Portal.

   • Page Settings > Company Name — Specify a name to display in the upper right corner. For example:

     

   • Page Settings > Company Logo — Select an image to display in the upper right corner. For example:

     

     If you specify this option, Page Settings > Company Name is ignored.

   • Title — Specify the title of the dashboard.

     If you specify a title, the main area of the User Portal displays the title of the dashboard. Otherwise, it displays the name of the dashboard.

     Also see “Preparing for Folder Item Localization” in Implementing InterSystems Business Intelligence.

   • Owner — Specify the InterSystems IRIS® user who owns this dashboard. If a dashboard has an owner, then only the owner can specify the Resource option for the dashboard; see the next item.

   • Resource — Specify the resource that is used to control access to this dashboard. See “Visibility of Folders and Folder Items,” in the chapter “Using the Portal Features” in Using Dashboards and the User Portal.

   • Category — Specify the category to which this dashboard belongs. The User Portal uses this to group items in the Covers View. See the Using Dashboards and the User Portal.

   • Description — Briefly describe the dashboard.

   • Keywords — List any keywords or phrases to help you find this dashboard later. Specify a comma-separated list of keywords or phrases.

     These keywords are displayed in the User Portal.

   • Resize — Select this option to control whether users can move and resize the widgets on the dashboard.

   • Modify — Select this option to control whether users can modify the widgets on the dashboard.

   • Title Bars — Use this submenu to control the display of title bars on the widgets on this dashboard. You can also customize their appearance. This submenu has the following options:

     • Title Bars — Select ON or OFF.

     • Title Bar Color — Select a color to use for the title bar, to be used by default.

     • Title Bar Opacity — Specify the opacity of the title bar, to be used by default. The value 1 means 100%.

     • Text Color — Select a color for the text of the title bar, to be used by default.

     • Selected Color — Select a color to use for the title bar, to be used when the widget is selected.

     • Selected Opacity — Specify the opacity of the title bar, to be used when the widget is selected. The value 1 means 100%.

     • Selected Text Color — Select a color for the text of the title bar, to be used when the widget is selected.

     • Font — Select the typeface to use for the text in the title bar.

   • Widget borders — Use this option to hide or display borders on all widgets.

   • Work Lists — Specify the number of worklists in the dashboard. Note the following defaults:

     • In a two-worklist dashboard, by default, the top worklist is the Filters box, and the bottom worklist is the Favorites/Recent items box.

     • In a one-worklist dashboard, by default, the worklist is the Filters box.

   • Background — Use this submenu to specify the background of the dashboard. This submenu has the following options:

     • Background Color — Select the background color. Note that this color is used only if

     • Background Image — Select an optional background image. If you choose an image, the Background Color option is ignored.

     • Background Opacity — Specify the opacity of the background color or background image (whichever is used). The value 1 means 100%.

   • Scalable Grid, Grid Rows, and Grid Columns — Use these options to specify the position and size of all widgets relative to a resizeable grid.

     If you enable the Scalable Grid option, when you move a widget, the upper left corner of widget aligns to the nearest grid point. Similarly, when you resize a widget, the lower right corner aligns to the nearest grid point. Use the Grid Rows and Grid Columns options to specify the grid. Note that the grid itself is not displayed.

     If you resize the dashboard, all the widgets are automatically resized. Scalable Grid is the only option that supports this resizing behavior.

   • Snap Into Place — Use this option to control how widgets are placed on the dashboard. If you clear this option, you can position widgets freely anywhere on the dashboard, even overlapping each other. If you select this option, the system automatically aligns the widgets next to each other or below each other.

     This option is available only if you clear the Scalable Grid option.

   For details on the other parts of the Dashboard Editor, see the following chapters:

   • Adding Pivot Table Widgets

   • Adding Chart Widgets

   • Adding Meter Widgets

   • Adding Scorecard Widgets

   • Adding Other Widgets

   • Adding Widget Controls

   In some cases, the changes are saved automatically.

   In other cases, the system does not save the changes automatically. In these cases, it displays an indicator like the following as a reminder:

   

   In such cases, save the dashboard as described in “Saving a Dashboard.”

Adding a Widget to a DashboardCopy link to this section

To add a widget to a dashboard, use the following general procedure:

1. Display the dashboard as described in “Displaying Business Intelligence Dashboards,” earlier in this book.

2. If you make unrelated changes to the dashboard, and if you want to keep those changes, save them.

   When you add a widget, the Dashboard Designer saves the dashboard with the newly added widget but discards other unsaved changes.

3. Do one of the following:

   • Click Menu > Add New Widget... — Use this option to add a new widget that does not include any configuration details.

   • Click Menu > Add Widget from Catalog.... — Use this option to reuse a configured widget that you previously saved to the widget catalog.

     You can reconfigure this widget, if needed; you can change any detail except for the widget type. However, you generally use this option when you have saved widgets that are already configured in common ways for your needs.

   • Display the Dashboard Editor, click Widgets, and then click the plus sign button.

   The system then displays a wizard where you select a widget and specify basic information for it.

4. Navigate to a widget type and (if applicable) subtype.

5. (For most types of widgets) Optionally specify of the following items:

   • Data Source — Select the data source for this widget. See “Names of Data Sources” and “Kinds of Data Sources,” later in this chapter.

   • Link to — Select another widget on this dashboard to use as the source. See “Linked Widgets,” later in this chapter.

   Or specify a data source later, as described in “Specifying the Data Source for a Widget.”

6. Specify a name for Widget Name. Note that each dashboard widget must have a name.

7. Click OK to add the widget to your dashboard.

8. Optionally configure the widget. For information on specific types of widgets, see the following chapters:

   • Adding Pivot Table Widgets

   • Adding Chart Widgets

   • Adding Meter Widgets

   • Adding Scorecard Widgets

   • Adding Other Widgets

9. Optionally add controls to the widget. See the chapter “Adding Widget Controls.”

Overview of Widget TypesCopy link to this section

This section provides an overview of widget types.

Reconfiguring a WidgetCopy link to this section

When you reconfigure this widget, you can change any detail except for the widget type. To select and reconfigure a widget on a given dashboard:

1. Display the dashboard as described in “Displaying Business Intelligence Dashboards,” earlier in this book.

2. Display the Dashboard Editor.

3. Click Widgets.

   The system then displays a list of the widgets in the dashboard.

   

4. Click the name of the widget in this list. This action selects the widget.

   The system then displays a list of settings that you can modify. In most cases, the list includes submenus. The following shows a partial example:

   

5. Optionally specify the following settings, which all widgets have:

   • Name — Specify a name for internal use within this dashboard. One widget can refer to other widgets (for example, to filter another widget). For these names, you might want to establish a set of naming conventions, for your convenience.

   • Title — Specify any text to display in the title bar of the widget.

     Note that the dashboard can be configured to hide all title bars; see “Modifying Dashboard Settings.”

   • Toolbar — Configure the toolbar for this widget. See the first subsection for details on this submenu.

   • Sidebar — Configure optional sidebar text for this widget. See the second subsection for details on this submenu.

   The other submenus list additional items, depending on the kind of widget you select. For information, see the following chapters:

   • Adding Pivot Table Widgets

   • Adding Chart Widgets

   • Adding Meter Widgets

   • Adding Scorecard Widgets

   • Adding Other Widgets

   • Adding Widget Controls

Sidebar SettingsCopy link to this section

Use this submenu to configure optional sidebar text for the widget, which is displayed in a rectangle on the right side of the widget, as in the following example:

Specify the following options:

• Sidebar — This option enables or disables the sidebar. Select ON or OFF.

• Sidebar Content — Type the text to be displayed in the sidebar. You can include simple HTML markup such as the <p> and </p> tags, the <br> tag, the <i> and </i> tags, and the <b> and </b> tags.

  If you enclose text in the <p> and </p> tags, that text is automatically wrapped as shown in the preceding example.

• Sidebar Width — Specify the width of the sidebar. Specify either a number (which is interpreted as the width in pixels) or a number followed by % (which is interpreted as a percentage of the width of the entire widget).

Specifying the Data Source for a WidgetCopy link to this section

To specify the data source for a widget:

1. Access the Dashboard Editor and select the widget as described in “Reconfiguring a Widget.”

2. Click Type & Data Source.

   The system then displays the Type and Data submenu.

   

3. Specify one of the following options:

   • Data Source — Select the data source for this widget. See “Names of Data Sources” and “Kinds of Data Sources.”

   • Link to — Select another widget on this dashboard to use as the source. See “Linked Widgets.”

   • Drilldown Target — This option enables the user to double-click a cell and access another dashboard. The newly opened dashboard is filtered by the context in which the user double-clicked. For example, if the user double-clicks in a cell that shows data for a specific city, the newly opened dashboard is filtered to that city.

     To use this option, click the Search button , click a dashboard, and click OK.

   Note that the Widget Type option enables you to choose a different widget subtype; it does not let you choose a type. See “Widget Types and Subtypes,” earlier in this chapter.

The following subsections provide details.

Names of Data SourcesCopy link to this section

When you specify the data source for a widget, you refer to that data source by name. This logic simplifies the process of deploying dashboards and pivot tables to end users. But it also means that if you rename items, you must update any dashboards that use those elements.

When you open a dashboard, if the system cannot find a data source that it uses, the system displays as much of the dashboard as possible. For example:

Saving a Widget to the Widget CatalogCopy link to this section

You can copy a widget (including all its configuration details) to the widget catalog. To do so:

1. Display the dashboard that contains the widget. See “Displaying Business Intelligence Dashboards,” earlier in this book.

2. Display the Dashboard Editor.

3. Access the Dashboard Editor and select the widget as described in “Reconfiguring a Widget.”

4. Click Menu > Save Widget to Catalog ... .

   The system displays a dialog box in which you specify details for the widget in the catalog.

5. Specify Folder, Widget Name, and other options. For information, see “Adding a Widget to a Dashboard,” earlier in this chapter.

6. Click OK.

   If you have already saved a widget with this name, in the given folder, the system prompts you to confirm that you want to overwrite the previously saved widget.

7. Click OK.

   No change is made to the dashboard itself.

The saved copy does not include any local overrides. That is, if you have customized the pivot table by using the Mini Analyzer, those customizations are not included in the widget catalog.

Removing a Widget from a DashboardCopy link to this section

To remove a widget from a dashboard:

1. Display the Dashboard Editor.

2. If you make unrelated changes to the dashboard, and if you want to keep those changes, save them.

   When you remove a widget, the Dashboard Designer automatically saves the dashboard, now without the removed widget. In this step, the Dashboard Designer discards other changes that you made and did not save.

3. Click Widgets.

4. Click the X button next to the widget name. The change is saved automatically.

Clearing the Autosave State of a DashboardCopy link to this section

If the autosave feature for the User Portal is enabled, then when you display a dashboard, the User Portal displays that dashboard with any unsaved changes that you might have made. To remove these unsaved changes, click Menu > Clear Autosave State. Then the User Portal displays the dashboard as defined in its saved definition.

Or save the dashboard, thus saving the changes and changing the definition. See the next topic.

Saving a DashboardCopy link to this section

To save the dashboard you are working on, do one of the following:

• Click Save.

  

  The system saves the dashboard immediately.

• Click Menu > Save.

  The system saves the dashboard immediately.

• Click Menu > Save With Options....

  Specify some or all of the following options and then click OK:

  • Folder — Specify the folder, if any, to which the dashboard belongs. Either type a folder name or select an existing folder. If desired, use the slash character (/) to specify a subfolder. For example, you can enter the following for Folder:

    My Folder/My Subfolder

    Copy code to clipboard

    Do not start the first folder name with a dollar sign ($); if you do, the dashboard definition is accessible only in Studio.

  • Dashboard Name — Specify the name of the dashboard.

  For information on the other options, see “Modifying Dashboard Settings,” earlier in this chapter.

Or use Menu > Save As.... See the next section.

Copying a DashboardCopy link to this section

To copy a dashboard, do the following:

1. Display the dashboard as described in “Displaying Business Intelligence Dashboards,” earlier in this book.

2. Click Menu > Save As....

3. Specify the options as described in the previous section (and in “Modifying Dashboard Settings)”

4. Click OK.

Deleting a DashboardCopy link to this section

One way to delete a dashboard is as follows:

1. Display the dashboard as described in “Displaying Business Intelligence Dashboards,” earlier in this book.

2. Click Menu > Delete Dashboard.

   The system prompts you to confirm.

3. Click OK.