Consolidated Jump To Dashboard Plugin
*This plugin is officially supported by Sisense. You can find the latest version of this plugin on the Sisense Add-Ons page.
Introduction
The following article describes the steps needed to jump into a target dashboard (via new tab / popup window) from a selected widget with applied scope.
Clarifications:
-
This plugin unites all previous plugins published (drillToDashbaord /drillToPopUpDashbaord):
https://support.sisense.com/entries/60285470-Drill-to-Pop-Up-Dashboard
https://support.sisense.com/entries/57530174-Jump-to-sheet-with-applied-scope
https://support.sisense.com/entries/61485854-Drill-to-Dashboard
-
This plugin supports charts, pivots and indicators
-
In order to jump to the related dashboard: Right click on the widget, and choose the option "Jump to ..."
-
Supported filters that transferred to target dashboard
-
Pivots: dashboard filters, widget filters, measured values
-
Charts / Indicators : dashboard filters, widget filters
- Changing widget type looses the jump definition, needs to be reconfigured
- When importing a dashboard to another environment Jump needs to be reconfigured
- If you are using an older version of the Image Plugin it will cause the new image indicator smear - image plugin was updated, replace it with the old file
Business Case
An effective business intelligence dashboard should tell the user key things s/he needs to know about the business, in a flash, and still enable the user to drill down into data. This plugin enables the user to present additional information about specific series on demand (=by jumping into a target dashboard from a widget), without the need to present all the data in one dashboard.
Example
Jump to Pop-Up Dashboard:
Steps
Step 1 - Download and extract the enclosed folder into the plugins folder:
C:\Program Files\Sisense\PrismWeb\plugins\jumpToDashboard, if the "plugins" folder is not there, create it
***Please rename the folder name to "jumpToDashboard"
***If you have previous Jump/Drill plugins, remove them
Step 2 - Creating your target dashboards
Create the target dashboards, use the “_drill_” prefix to indicate this is a target dashboard (default setting define that target dashboards won't appear to the users in the dashboards list, and are accessible only when jumping to them)
Step 3 - Defining 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. Click apply to save the changes.
Step 4 - Jumping to target dashboard
Once a target dashboard is defined, right click on a point/cell and choose "jump to dashboard"
Indication icon is added to the “Jumpable” widgets:
Additional configurations
The default settings of the JumpToDashbaord plugin, doesn't requires any JS configuration. However, you can change the settings per widget by editing the widget’s script. Inside a widget’s edit mode, click on edit script, paste the below code (after editing the required parameters), click save, refresh the widget and click apply.
JS code:
prism.jumpToDashboard(widget, { <parameter> :<Value>});
When changing few parameters, the below syntax should be used:
prism.jumpToDashboard(widget, { <parameter> :<Value>,<parameter>
:<Value>,<parameter> :<Value>});
To remove all setting defined (erasing the script will still keep the previous settings):
prism.jumpToDashboard(widget, { });
Default settings can be changed by editing the config file located in the plugin folder:
C:\Program Files\Sisense\PrismWeb\plugins\jumpToDashboard\js\config.js
Configurable parameters :
Examples:
-
To change jump type into pop-up mode, and hide panels:
prism.jumpToDashboard(widget, {drilledDashboardDisplayType:2,
displayFilterPane:false, displayDashboardsPane:dispfal
se, layToolbarRow:false, displayHeaderRow:false });
- To exclude country and brand filters when jumping to target dashboards:
prism.jumpToDashboard(widget, { excludeFilterDims
: "[country.Country],[brand.Brand]"});
***Note - Ad blocking programs might disable the plugin functionality
***Plugin update history is now included in an attached .txt file
*** Might experience jumping issues with shared users in version 6.2.0, solved in version 6.2.1
Update on November 28th, 2016 - jump to dashboard link covered all widget including the header - fixed.
Added Pop-up Resizer(can be enabled from config or from Widget script)
Update on May 16, 2017 - fix for text widget mouse pointer indicating clickable state
Update on May 25, 2017 - fix for resize window icon for v.6.6.1
Update on August 24, 2017 - fix for the Richtexteditor edit issue with installed JTD plugin
Update on December 28, 2017 - We added a new parameter to the parameters which is:
- name: showJTDIcon
- description: Rather to show an icon for widgets that has JTD in the widget title
- type: boolean
- default: true
Update on January 24, 2018 - the plugin was fixed to work with version 7.0
Update on June 06, 2018 - bug fixes
-
Hey @Andrew, thanks for your input. Unfortunately they already have the _drill (my mistake in the original post) and the dashboard has already been published. Another details... When I first installed the plugin, the initial dashboard I made to _drill, was available. Now this SAME dashboard is not available to drill down to. Only on the original "parent" dashboard is it available.
-
Hi Alex,
go to Jump to Dashboard plugin folder and go to js folder, in there you will find config.js file. There is a setting for drilled dashboard prefix, change it to empty string. This way you will see all of them. I would then correct any naming issue, set jump to again, and then reinstate proper prefix.
-
Do you have multiple elasticubes/datasources? If so, are the new dashboard and the _drill dashboards on the same source?
I found I could only assign a drilldashboard if the parent dashboard was on the same data source as the parent, even if the datasources shared their structure.
Iris
-
has anyone experienced any issues with drillToDashboardNavigateTypePivot since the last update We used to be able to right click and select the jump to option for pivots (options 1) but since the last update we can not longer get this option to work, we can only get option 2 with each cell hyperlinked to work
We have turned off all plugs apart from jump to and the issue continues
-
Hi Chris,
Thanks for commenting with the issue. Our team have looked into it and fixed the plugin. Please download the latest version from the official add-ons page and let us know if the plugin works for you as expected.
Here is the link: https://www.sisense.com/product/add-ons/ (also found in the post).
Thanks,
Oxana
-
Hello,
I have exactly the same questions as Mike has mentioned before but got not answered.
I have a pivot table and by default all numbers are highlighted. I would like to be able to select the column which is highlighted and further I would like to show different drill dashboards per column. Is that possible?
Is it also possible to highlight a column with text?
Thank you very much
Antti
-
Hello,
We are facing an issue after updating to 7.0.2 of Sisense with the jumpToDashboard plugin.
We updated the plugin to the most recent version available. However, it seems to be not working with Cascading / Dependent filters in place. For Example, the link on the Pivot table values disappears and wont let you jumpto a drill dashboard.
However, it works properly if we try to create a new widget and apply the jumpToDashboard even with the Dependent Filters
Has anyone faced a similar kind of issue? Any Suggestions / Resolutions will be helpful.
Thank You in advance!
-
What IE11 settings are required for the drillto to open? We never have an issue with these opening in Chrome, and they sometimes work on IE11, but not others. Are there specific IE11 settings that prevent the drillto from opening? There are no warnings, errors, etc. that appear to help troubleshoot.
Thank you.
-
Has anyone found a way to change a date filter in the script for a widget before jumping through.
Specifically, I have
- A filter set the 5/31/2018
- A widget that displays a count based on YTDSUM(ProjectsStarted)
- When I click the widget I want to pass through the filter 1/1/2018 through 5/31/2018 and not just 5/31/2018
This way on a jump I could show the actual projects that where started
I wonder if there is some way to do this using the jump to dashboard widget?
-
I'm seeing a strange issue with embedded dashboards, in that the jump-to-dashboard plugin doesn't take into account the most recent filters set on the dashboard, instead using the filters the dashboard is loaded with as embedded.
For drilling into a dashboard from an indicator widget, this is inconvenient but can be worked around by including the filter pane in the drill dashboard. But this makes the use of the jump dashboard from a pivot completely useless -- the filter from the pivot row is not included on the drill dashboard.
(I already submitted a ticket for this, but perhaps someone here has ideas)
-
@Antti Wolk
Jumping from same widget to different dashboards is currently not supported, we'll review the request and see if it can be incorporated in future versions.
@BI Reporting
Looks like undesired behavior, it will require troubleshooting, please open a ticket and we'll follow up.
@Karen Mullner
Im not familiar with any special IE issues, when it happens can try opening developer tools (F12) and see if there are any error there?
@Mike Van
The required functionality is currently not supported. Please reach out to your customer success manager and we'll review the request with him
@Iris Maessen
Im not sure I completely understood the issue, since you submitted a ticket, we'll have someone take a look at it.
-
I'm having the same issue as Iris Maessen. When I use the Jump-to-Dashboard widget, only the default filter settings from the main dashboard are used, regardless of whether those settings have been changed. I've attached two screenshots to illustrate the point. The one named Main_edit.jpg shows the main dashboard with a filter named "Feedyard" visible. You can see that the selection is limited to "10156". The other screenshot named Jump_edit.jpg shows the Jumped-to dashboard (display type 2) with the main dashboard visible in the background and the filter pane visible in the Jumped-to dashboard. As you can see, the selection in the "Feedyard" filter is changed back to the default value for the main dashboard, "10135", rather than the selected value of "10156". The plug-in isn't passing through the current filter selections from the main dashboard to the Jumped-to dashboard. Kind of takes away the whole point of having a Jump-to-Dashboard widget.
-
I am having trouble with this plug-in causing IE 11 to crash in certain circumstances. I am using Sisense version 7.1.2.11001 and have the latest version of the plug-in.
I think I've narrowed the problem down to when there is a Table-type widget that contains data (not empty) on the dashboard above the "jumpable" widget. In this scenario the dashboard initially loads just fine, but attempting to jump to the other dashboard causes IE to crash immediately:
When I change the type of the Table widget and make it a Pivot widget, or if I move the Table widget to a separate column to the right of the jumpable widget, the jump is successful and IE does not crash.
Chrome is able to jump successfully without changing the widget type or position.
Unfortunately, as an OEM we really need this to work in IE so it is compatible with our software. Changing all our table widgets to pivots might be workable but certainly wouldn't be ideal. Right now this issue is a barrier for us to upgrade from Sisense version 6.6.0 to 7.1.2.
-
We seem to be having issues with certain widget types under 7.0.2, where only indicators and pivots will work. Other supported types like bar and column charts let us select a jumpto destination, and show the jumpable icon, but nothing happens. We have no errors in Chrome console.
Our dev environment is running 7.2 (unsupported as of yet, I know), and the problem persists there as well, and it occur in both chrome, firefox, and IE. I've installed the latest available version and cycle the plugin off/on to no avail. -
FYI - if you need to use the widget script to modify the jTD behavior, boolean true or false parameter values must be in all lower case. for example:
// to open the jTD as a popup, then hide filter pane, dashboard pane and the toolbar:prism.jumpToDashboard(widget, { displayFilterPane :false, drilledDashboardDisplayType :2,displayDashboardsPane :false, displayToolbarRow :false });The list of possible configuration parameters is listed here: https://www.sisense.com/marketplace/jump-to-dashboard/ , just make sure to ignore mixed case True / False in that article and use lowercase true or false instead. -
Cache McClure and Iris Maessen, I too have experienced trouble with the filters failing to pass to the jumped-to dashboard. It seems that filter passing only works when you are the owner of the jumped-to dashboard.
Sisense dev team, I believe you can fix this by passing the filters as a query parameter into the iframe url instead of doing a PATCH on the jumped-to dashboard via the REST API.
-
I'm having an issue where when I try to select a target dashboard, there's only one target available; even though I have like 6 dashboards that hold the prefix.
I'm also having the same issue as James McKenzie, Cache McClure and Iris Maessen It's displaying like it is using the filters but its not filter the data.
-
Hey Delsaran,
It's probably because of 1 of 2 things:
1) The other _drill dashboards are using different elasticubes
2) The other _drill dashboards are located in different folders.
Regardless, if you add the JTD as a widget script instead of using the checkbox, it'll work fine.
Best,
Elliott
-
We are experiencing problems with jumpto in IE 11, i am using version 11.0.105.
As an editor the jumpto option on the widget does not appear on the menu, so therefore cannot select a dashboard to jump to.
As a view user no defined jumptos are available, it is almost like the plugin is not loading at all, on inspection of the code of the dashboard the icon where it would display that a jump to is available it not even included in the code.
This works fine in Google Chrome, Firefox and even Microsoft Edge 41.16299.820.0.
Does anyone have any clues about settings for IE11??
-
Script documentation indicates that drilledDashboardDisplayType parameter default is 1 which is new tab. However when you do not enter this parameter, default is to open in Popup.? When I use the parameter and enter any of the choices, it does not seem to have any effect. I tried putting the selection with and without quotes.
prism.jumpToDashboard(widget, {drilledDashboardDisplayType:'1',displayDashboardsPane : false, displayFilterPane : false,displayToolbarRow : false, hideDrilledDashboards : true, displayHeaderRow:false});
Default Value: 1
Possible Values:1 New tab 2 Popup window 3 Current tab -
In the most recent version of this plugin, combined with Sisense 7.4.0, I'm no longer seeing the option to assign a Jump dashboard in the widget menu. (Even after deactivating all other plugins)
Existing JTDs work, and I can assign a JTD through Blox so I assume I can also still assign a JTD using the widget script but I would prefer the assignment through the menu.
-
Hello,
I am a new user.
I enabled the Jump to plug in and used it.
For some reason, I cannot share it with any user or group.
Other users can see the jump to option when right clicking but it does not open the _drill_ dashboard.
When I am trying to share, I dont see any user or group in the list.
What am I doing wrong?
Thanks
Sagi
Please sign in to leave a comment.
Comments
132 comments