Dashboard Designer

The Dashboard Designer page allows user to

select a preset layout add report parts to a dashboard customize dashboard layout edit dashboard description and background copy and move dashboard switch to presentation mode

configure sharing access add subscriptions and scheduled delivery print dashboard email dashboard dashboard filters

Create a New Dashboard

1. Click the plus icon (+) next to Dashboards to create a new one.

2. Select a preset layout from the pop-up.

   User can always add and remove tiles in the preset layout afterwards.

   

   Fig. 272 Dashboard Add Icon and Preset Layout
   

3. Select to either create a “text” dashboard tile or include an existing report part in each one.

   

   Fig. 273 Report Part or Text options
   

4. For a “text” dashboard tile, click the Configuration mode (page flip) icon to input the content.

   

   Fig. 274 “Text” Dashboard Tile
   

   1. Optionally enter a title and description.

   2. Click the gear icons (⚙) to format the title and description.

   3. The title and description are limited to one paragraph of text and simple formatting:

      • font face and font size.

      • text effects bold, italic, underlined.

      • font color and background color.

      • text alignment.

   4. Enter the content into Body Text.

   5. This section supports unlimited amount of text and more formatting options:

      • Bullet List and Numbering List.

      • Indented text.

5. For existing report part option, use the Report Part Selection pop-up to search and use an existing report part:

   1. Optionally specify a report category or sub-category.

   2. Type a partial text in Report Name to search for the containing report first.

   3. Other search options include Created By, Created Date, Last Edited By and Last Edited Date.

   4. Click Search to see the list of matching reports.

   5. Select a report to display the list of child report parts.

   6. Select the right report part and click OK to use it.

   

   Fig. 275 Report Part Search
   

6. Repeat for other tiles then click Save at the top to save the dashboard.

Following is a sample dashboard with 3 tiles: a comparison column chart, detail grid and a text part for the summary:

Fig. 276 Sample Dashboard

Customize Dashboard Layout

The dashboard tiles can be added, copied, resized, moved around, swapped in position and deleted.

1. 

   Fig. 277 Title Bar

   Move the cursor over the title bar to see Copy, Configuration/View mode, Fullscreen and Delete buttons.

2. Switch the tiles back to View mode to be able to change the layout.

3. Place the cursor over the edges of dashboard tiles then click and drag to resize them.

4. Move the cursor over the title bar then drag to move the tiles.

5. Drag a tile onto another to swap them.

6. Click the Add Dashboard Tile button at the top to insert a new tile at the end.

Edit Dashboard

Fig. 278 Edit Menu

The Edit menu allows user to:

• Set a description for the dashboard.

• Set background color.

• Set background image:

  1. Select Set Background Image to open Background Image Settings pop-up.

  2. Enter the url of the image.

  3. Choose to stretch or center the image.

  4. Click OK to close the pop-up.

• Copy or Move dashboard, this is similar to Report (Copy a Report and Move a Report).

• Hide or show report part filter descriptions in dashboard.

Switch to Presentation Mode

Click the Presentation button at the top to switch to Presentation mode.

Fig. 279 Presentation Mode

• In this mode, each dashboard tile takes turn being displayed for a configurable time.

• The sub toolbar allows user to configure the slide transition time and switch to fullscreen.

Note

Using report parts with short data refresh intervals together with presentation mode in fullscreen can effectively make up a live slide show dashboard.

Configure Sharing Access

1. Click the Access button at the top to open Access screen.

2. Click the Add Sharing button to add a new sharing.

3. Select either Everyone, Role, or User from the Share With drop-down.

4. For Role or User, select a specific one from the drop-down.

5. Select a permission from Acces Right drop-down (See details in List of Access Rights table below).

6. Click Save button at the top to save the list.

Fig. 280 Sharing Access

Table 7 List of Access Rights

Interact with shared report	Full Access	Save As	Locked	View Only	No Access
View the dashboard with filter interaction	✔	✔	✖	✔	✖
View the dashboard with NO filter interaction	✖	✖	✔	✖	✖
Save changes in the dashboard	✔	✖	✖	✖	✖
Save As changes in the dashboard	✔	✔	✖	✖	✖

Table 8 Access Rights Precendence (Higher Right covers lower ones)

Access Right
Full Access
Save As
Locked
View Only
No Access

Another function of this screen is to change the Dashboard Owner (next to the dashboard name):

1. Click the plus icon to open All Users pop-up.

2. Select either User Name, Email Address or Role to search for. Select All to search for all fields.

3. Type a partial name into the search box and click the search icon (🔍).

4. Only matching users will be displayed.

5. Select the user then click OK to close the pop-up.

6. Click Save button at the top to save the dashboard together with the owner.

Add Subscriptions

1. Click the Subscribe button at the top to open Subscription screen.

2. Dashboard Subscription is similar to Report List.

3. Click the Subscribe button again to close Subscription screen.

Add Scheduled Delivery

1. Click the Schedule button at the top to open Schedule screen.

2. Dashboard Schedule is similar to Report Schedule.

3. Click the Schedule button again to close Schedule screen.

Print Dashboard

1. 

   Fig. 281 Print Options

   Click the Print button at the top and select either HTML or PDF format to open Print pop-up.

2. Select print options in the left menu while the print preview is reflected on the right:

   • Select a target printer using Change button.

   • Select specific pages to print.

   • Increase the number of copies, then tick the Collate check-box to have the pages of each copy printed separately, instead of being mixed together.

   • Select a page layout Portrait or Landscape.

   • Select a paper size.
     

   • Select a margin option. In Custom mode, the margins in preview pane can be resized interactively.

   • 

     Fig. 282 Custom Print Margins

     Select a print resolution in Quality drop-down: the higher the number of dpi, the clearer and more detailed output.

   • Select to print headers and footers or not.

   • Select to print background images or not.
     

3. For more advanced options, click the link Print using system dialog… to use the system Print dialog.

Email Dashboard

The dashboard can be delivered via email on-demand (instead of Scheduled Delivery) using the Email button:

1. Choose a delivery method Link or Embedded HTML to open Compose Email pop-up with the email template already populated.

2. Fill in the To, Subject and optionally CC boxes.

3. Optionally select the delivery method Link, Attachment or Embedded HTML.

4. Click OK to close the pop-up and send the email.

Dashboard Filters

1. The filter section on the dashboard will only show common filters between all report parts used in the dashboard.

2. By default, common filters are defined as the same field from the same table in the same schema of the database utilizing the same filter operator.

3. Common filter definitions can be altered in Settings > Data Setup > Advanced Settings > Others > Determine common filter for the same field based on. The following options are available:

   • Same field of the same data object from the same database schema (Default)

   • Same field name regardless of database schema or connection string

   • Same alias name regardless of database schema or connection string

   Notes: From version 2.15.0, the Use Lookup checkbox states are also considered when determining dashboard common filter.

4. Stored procedures used in reports follow the same logic as above.

5. Any filters which are not common between all report parts are available on the back of the report part tile. The user can flip the tile and update results to change the filters for the specific report part.

6. Common filters query only one instance of a common filter (the first one in the dashboard), for data driven filters (checkbox, selection, tree, popup style filters where the user is presented data for selection). This means when Field A is common, based on rules set above, only the first instance of the field which is common will be queried to pull results for common filter data.

7. Common filter order in the dashboard is set by the top most left dashboard tile. The filters associated with this report will be used to set the order. This order will update when a new tile is added, a tile is removed, and on saving the dashboard. The order is not recalcualted as tiles are moved around on the dashboard.