Jump to Dashboard

By:
Sisense
Download Now
  • Technical Details
The Jump to Dashboard add-on creates shortcuts from a widget in one dashboard to another widget in another dashboard via a new browser tab or a popup window. The Jump to Dashboard add-on supports charts, pivots and indicators. This add-on is useful for presenting additional information about specific series on demand by jumping across dashboards without the need to present all of the data in a single dashboard. After you have installed the add-on, you can right-click a value in the widget and jump to the relevant dashboard or depending on your configuration, click the widget to automatically jump to a default dashboard.

To install the Jump to Dashboard add-on:

  1. Download the attachment.
  2. Extract the .zip folder into the plugins folder. If the folder does not exist, create it prior to extracting the .zip file.
    For V7.1 and earlier: C:\Program Files\Sisense\PrismWeb\plugins
    For V7.2 and later: C:\Program Files\Sisense\app\plugins
  3. After those files have been unzipped there, you may also have to restart the web server.
  4. Create the new dashboards that you want to jump to. When naming the new dashboard, add the prefix “_drill_” to the title to indicate this is a target dashboard. The default settings define that target dashboards won’t appear to the users in the dashboards list, and are accessible only when jumping to them.
  5. Define the target dashboard in a widget. Enter the editing mode of the desired widget, click on the settings icon, and choose the target dashboard from the possible target dashboards created.
  6. Click Apply to save the changes.

Customizing the JumptoDashboard Add-on:

While the default settings of the JumpToDashboard add-on do not require any JavaScript configuration, you can change the settings per widget by editing the widget’s script. This allows you to modify the add-ons default behavior such as how to navigate to your target dashboards or what prefix determines which dashboards can be targets.

Default settings can be changed by editing the widget’s script or from the config file located in the plugin folder:

…Program Files\Sisense\PrismWeb\plugins\jumpToDashboard\js\config.js
When changing the config file, the settings will apply on all widgets using the plugin unless stated otherwise. The definitions in the widget editor, if defined, would override any configurations defined in the config file.

For a full list of all the changes you can make, see the Parameters table below.

To customize the JumptoDashboard Add-on:

  1. Inside a widget’s edit mode, click on Edit Script.
  2. Paste the code below (after editing the required parameters).
    prism.jumpToDashboard(widget, { <parameter> :<Value>});
  3. Click Save and refresh the widget.
  4. Click Apply.

Parameters

The following table provides a list of parameters you can modify in the configuration JavaScript file.

The code below can be modified Paste the code below (after editing the required parameters):

prism.jumpToDashboard(widget, { <parameter> :<Value>});

When changing few parameters, the below syntax should be used:

prism.jumpToDashboard(widget, { <parameter> :<Value>,<parameter> :<Value>,<parameter> :<Value>});

For example: prism.jumpToDashboard(widget, { displayDashboardsPane:false, displayToolbarRow :false, displayHeaderRow :false});

To remove all setting defined (erasing the script will still keep the previous settings):

prism.jumpToDashboard(widget, { });

Note: When excluding the date dimension using parameter excludeFilterDims, (Calendar) must be used or the exclusion will not work.  Example: [Table.Dimension(Calendar)]

Release Notes

Parameter Description Configured In Value Types Values
drilledDashboardDisplayType Defines how to display the drilled dashboard. Configuration File/Widget DisplayTypeId Default Value: 1
Possible Values:1 New tab 2 Popup window 3 Current tab
drilledDashboardPrefix The prefix of the drilled dashboards name. Configuration File String Default Value: “_drill_”Possible Values: An prefix
drilledDashboardsFolderPrefix The prefix of the folder, the dashboards inside which can be drilled to. String “”
displayFilterPane Determines if to display filter pane in the target dashboard window. Configuration File/Widget Boolean Default Value: truePossible Values: true/false
displayDashboardsPane Determines if to display dashboards pane in the target dashboard window. Configuration File/Widget Boolean Default Value: truePossible Values: true/false
displayHeaderRow Display header in the drilled dashboard window. Boolean true
displayToolbarRow Determines if to display toolbar in the drilled dashboard window. Configuration File/Widget Boolean Default Value: truePossible Values: true/false
volatile Volatile for the drilled dashboard window. Boolean true
hideDrilledDashboards Hides drilled dashboards from the dashboards navigator for non-dashboard owner users. Configuration File Boolean Default Value: TruePossible Values: true/false
drillToDashboardMenuCaption The caption for the drill to dashboard menu. Configuration File String Default Value: Jump to DashboardPossible Values: Any
drillToDashboardRightMenuCaption The caption for the drill to dashboard right menu. Configuration File/Widget String Default Value: Jump to DashboardPossible Values: Any
drillToDashboardNavigateType
drillToDashboardNavigateTypePivot
drillToDashboardNavigateTypeCharts
drillToDashboardNavigateTypeOthers		 Determines how to navigate to the configured drilled dashboard. Widget NavigateTypeId Default Value: 2Possible Values:1 Right-click on a pivot cell/ point or indicator Pivot, Indicator, Charts.2 Link on pivot measured cells Pivot.3 Click on Indicator widget, RichTextEditor, Image. Widget,
modalWindowWidth Modal window width when the selected display type is modal window. Configuration File/Widget Number Null
modalWindowHeight Modal window height whenhe selected display type is modal window. Configuration File/Widget Number Null
modalWindowResize Enable resize for modal window, In case the selected display type is modal window. boolean false
excludeFilterDims Dimensions to exclude from the drilled dashboard filter. Configuration File/Widget Array of DIM Default Value: []Possible Values: “[table.dimension]”
includeFilterDims Dimensions to include in the drilled dashboard filter. Configuration File/Widget Array of DIM Default Value: []Possible Values: “[table.dimension]”
showFolderNameOnMenuSelection Determines if to show the folder name or not inside the dashboards menu on edit widget mode. Configuration File Boolean Default Value: truePossible Values: true/false
showJTDIcon Determines if you show an icon for widgets that have JTD in the widget title. Widget Boolean Default Value: true
dashboardId Drilled dashboard ID. When set to null, a drilled dashboard menu will be available in the widget editor. Widget String Default Value: NullPossible Values: Dashboard ID
dashboardIds Multiple target Dashboards. Array of objects []{id:””, caption:””}
dashboardCaption Drilled dashboard caption. String null
sameCubeRestriction Use same ecube for the drilled dashboards Boolean true

April 4, 2018

The following issues were fixed:

  • jumpToDashboard plugin doesn’t set filter from formula in target dashboard
  • Jumping to a dashboard from a Pivot table – _drill don’t get the filters of the measured value
  • jumpToDashboard does not support the Base URL feature
  • jumpToDashboard uses unwanted dashboard filters
This is a free add-on, click here to get it now.

April 4, 2019:

  • Added support for BloX
  • Added support from mobile application
  • Passing filters column and table info to target dashboard