Skip to Main Content

MARKETPLACE

Jump to Dashboard

By Sisense

  • Navigation
Add-on Version 1.5.20
OS Support
Windows
Linux
Supported Sisense Versions (Linux) 7.4.3 - Latest
Supported Sisense Versions (Windows) 7.0 - Latest
Last Updated October 23, 2024
Tags
drill
explore
HIPAA
transition

This add-on is pre-installed on Sisense in Linux environments and its version could be different. The download link is for Sisense on Windows.

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. The target dashboard will be opened considering all the filters affecting widget where you jump from (including dashboard, widget and formula level filters).


Supported Chart Types

Jump to Dashboard works with the following chart types:

  • Pivot
  • Pivot2
  • Pie charts
  • Line charts
  • Area charts
  • Bar charts
  • Column charts
  • Indicators
  • Scatter charts
  • Polar charts

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 FilesSisensePrismWebplugins
    For V7.2 and later: C:Program FilesSisenseappplugins
  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.
    jum3 thumb 0 300
  6. Click Apply to save the changes.

Customizing the Jump to Dashboard Add-on:

While the default settings of the Jump to Dashboard 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 FilesSisensePrismWebpluginsjumpToDashboardjsconfig.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 Jump to Dashboard Add-on:

  1. Inside a widget’s edit mode, click on Edit Script.
    scripted1 thumb 0 300
  2. Paste the code below (after editing the required parameters).
    prism.jumpToDashboard(widget, { :});
  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, { :});

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

prism.jumpToDashboard(widget, { :, :, :});

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)]

Multiple Exclude Filter Dims

You can use multiple exclude filter dims. Enclose each dim in quotes and wrap them in square brackets. For example:

{     "actions": [         {             "type": "JTD",             "title": "Jump to Dashboard",             "data": {             "dashboardId": "5eebe311de960f2e8cf9811a", "args": { "drilledDashboardDisplayType": 1, "mergeTargetDashboardFilters": true, "excludeFilterDims": [ "[divisions.Divison_name]", "[Admissions.Admission_Time (Calendar)]", "[doctors.Specialty]" ] }} } ] }
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: true Possible Values: true/false
displayDashboardsPane Determines if to display dashboards pane in the target dashboard window. Configuration File/Widget Boolean Default Value: true Possible 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: true Possible Values: true/false
volatile Ignore changes applied to the destination dashboard. For example: editing widgets by a Designer, or changing the filters by a Designer or Viewer. Configuration File/Widget Boolean Default = true. Possible values: true/false
hideDrilledDashboards Hides drilled dashboards from the dashboards navigator for non-dashboard owner users. Configuration File Boolean Default Value: True Possible Values: true/false
drillToDashboardMenuCaption The caption for the drill to dashboard menu. Configuration File String Default Value: Jump to Dashboard Possible Values: Any
drillToDashboardRightMenuCaption The caption for the drill to dashboard right menu. Configuration File/Widget String Default Value: Jump to Dashboard Possible Values: Any
drillToDashboardNavigateType drillToDashboardNavigateTypePivot drillToDashboardNavigateTypeCharts drillToDashboardNavigateTypeOthers Determines how to navigate to the configured drilled dashboard. Widget NavigateTypeId Default Value: 2 Possible 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: true Possible Values: true/false
resetDashFilterAfterJTD Resets the filters of a target dashboard. Combine this with mergeTargetDashboardFilters if you want your dashboard filters to be displayed in the target dashboard. Configuration File Boolean Default Value: false Possible Values: true/false
showJTDIcon Determines if you show an icon for widgets that have JTD in the widget title. Widget Boolean Default Value: true
mergeTargetDashboardFilters Determines if you want your dashboard filters to be displayed in the target dashboard. Combine this with resetDashFilterAfterJTD. Configuration File Boolean Default Value: false
dashboardId Drilled dashboard ID. When set to null, a drilled dashboard menu will be available in the widget editor. Widget String Default Value: Null Possible Values: Dashboard ID
dashboardIds Multiple target Dashboards. Array of objects []{id:””, caption:””}
dashboardCaption Drilled dashboard caption. String null
sameCubeRestriction Use the same ecube for the drilled dashboards Boolean true

This is a free add-on. Click here to download.

Version 1.5.20 – Oct. 23, 2024

  • Bugfix: compatibility with the Metadata Translation plugin
  • Bugfix: cascading filter is not updated correctly when two date fields at different levels were placed in the pivot table
  • Bugfix: endpoint /api/v1/dashboards that is used by the add-on creates user instances of the shared dashboards
  • Bugfix: Pivot column is not passed to target dashboard in case there is disabled pivot column
  • Bugfix: Filter selections are passed with the display value but not actual raw value
  • Bugfix: “resetDashFiltersAfterJTD” config property doesn’t work in case “volatile” param is set to “true”

Version 1.5.14 – June 12, 2024

  • Bugfix: issues with Web Access Token authentication
  • Bugfix: locked filters become unlocked if they are passed to the target dashboard during the jump to dashboard.
  • Bugfix: when dashboard filters are set via query parameters, those filters are passed to the target dashboard during the jump, ignoring the user modifications to the filters on a dashboard.
  • Added new Display Type “Current tab with page refresh“ that allows passing of URL parameters to the target dashboard

March 28, 2024 – v1.5.7

  1. Bug fix: hide dashboard option (error in the console when click on “Embed code” option)
  2. Bug fix: add-on passes wrong value in a Date cascading filter when jumping
  3. Bug fix: issue when jumping from days in date column grand totals adds unrelated filters
  4. Bug fix: issue when background Filter not being honored when opening target dashboard
  5. Bug fix: column styles are not applied when the “Allow Jump To Dashboard” checkbox is selected
  6. Bug fix: Incorrect filters are being passed when jump from Pivot column header
  7. Bug fix: pivot styling (links) in widget editor is not properly applied
  8. Bug fix: missing JTD icon on native mobile app
  9. Bug fix: add-on is not interpreting > sign or < sign correctly
    when the value is passed via filter
  10. Bug fix: formulas containing multiple filters for the same dimension pass only the latest used filter on drill. After the fix, if there is only one filter related to a single dimension – we pass it. If there are multiple filters for single dimension – we do not pass any of them as filters
  11. Bug fix: pivot styling is applied before plugin config values are been applied
  12. Bug fix: jumping from value columns becomes impossible after a dashboard is restored using “Restore Dashboard” functionality.
  13. drilled dashboards were invisible for admin in case hideDrilledDashboards option is enabled

Nov 21 2023

  1. Bug fix: Sisense context menu is covered by browser context menu on Pie charts
  2. Bug fix: Jump from subtotal cell in Pivot applies wrong dashboard filter
  3. Bug fix: Empty widget after drill to dashboard and then opening the drilled dashboard from the dashboard menu
  4. Bug fix: Console errors on login page
  5. Bug fix:  Dashboard viewers receive 403 when jumping

18 Sept 2023

  1. Bug fix: add-on causes query error on Pivot when duplicating value with the “jump to dashboard” links
  2. Bug fix: fiscal date filter is not correctly passed to the target dashboard
  3. Bug fix: target dashboard filters datasource is not properly updated when “sameCubeRestriction” is set to “false”
  4. Bug fix: multiple browser tabs are opened when jumping

19 July 2023

  1. Bugfix: JTD doesn’t work from BloX when Quest add-on is enabled
  2. Bugfix: JTD sends dashboard filters that are disabled on the widget level from the source to the target dashboard
  3. Bugfix: incorrect date filter is passed in Sisense Mobile App

25 May 2023

  1. Added configuration parameter to send or not sent break-by dimension to the target dashboard
  2. Bug fix: Filters in shared formulas do not get applied when using JTD.
  3. Bug fix: Filters are not reset after JTD when resetDashFiltersAfterJTD is TRUE
  4. Bug fix: when jumping from the line chart widget, not all filters are passed

27 April 2023

  1. Bugfix: Widgets are displayed as “jumpable” when they’re actually not

22 March 2023:

  1. Added support to pass “break-by” dimensions as a filter to the target dashboard
  2. Added ability to jump from only specific value columns from the pivot widgets

6 Jan 2023:

  1. bug fixes

12 December 2022:

  1. bug fixes

17 July 2020:

  1. Support JTD when Sisense is embedded in an iFrame
  2. Support JTD on Pivot Table widgets with dependent filters

23 June 2020:

  1. Support of JTD for IE11
  2. Ability to select a dashboard to Jump to for Designers even when editing a widget’s script is forbidden

28 May 2020:

  1. Name of the dashboard in context menu “Jump to …” updates when the dashboard is renamed

April 21, 2020:

  1. Added support for CSRF

March 24, 2020:

  1. Support for Jump-to-Dashboard in iFrames
  2. 2nd level Jump-to-Dashboard
  3. Hide dashboards supported in Linux and Windows

February 24, 2020:

  1. Added support for Linux
  2. Fixed display the multiple dashboard options on Linux
  3. Fixed ‘Hide dashboard’ for Linux

April 4, 2019:

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

August 6, 2019:

  • Fixed the issue with not working navigation parameters on 6.7

August 14, 2019:

  • Added possibility navigate to target dashboard by it’s ‘name’ instead of ‘oid’. The option ‘drillToDashboardByName’ in the config file is turned off (false) by default. Need switch to true, for using ‘name’ instead of ‘oid’

September 19, 2019:

  • Fixed next configurable options: modalWindowHeight , modalWindowWidth , resetDashFiltersAfterJTD
  • Fixed compatibility with Sisense Iframe

October 19, 2019:

  • Fixed JTD in Blox arguments

October 31, 2019:

  • Fixed issue with the compatibility of Interactive pivot plugin

November 6, 2019:

  • Fixed issue with the missing scroll in JumpToDashboard list

November 11, 2019:

  • Fixed issue with the missing drilled dashboards in low screen resolution

November 15, 2019:

  • The context menu is not displayed when “Enable Drill to Anywhere” is turned off

November 21, 2019:

  • Fixed hideSharedDashboardsForNonOwner functionality on Sisense V8.0.1 and V8.1

April 4, 2018

Fixed the following:

  • jumpToDashboard plugin didn’t set filter from formula in target dashboard
  • Jumping to a dashboard from a Pivot table – _drill didn’t get the filters of the measured value
  • jumpToDashboard didn’t support the Base URL feature
  • jumpToDashboard used unwanted dashboard filters

Want the latest in analytics?