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
-
Thanks for putting this together!
I was wondering if you had any ideas on how to implement multiple drill through's for one widget? On the same widget, one column would drill through to one dashboard while another column would drill through to a different dashboard. Any ideas on how to accomplish this? -
Nancy,
Just tried using the ModalWindowWidth parameter at the widget level script.
prism.jumpToDashboard(widget, {displayDashboardsPane : false, displayFilterPane : true,displayToolbarRow : false, hideDrilledDashboards : true, displayHeaderRow:false, modalWindowWidth: 450});
It works fine. As I decrease the number the width of the pop up window gets smaller.
I didn't scan for the original question so maybe I am missing something.
-
@Rajiv - there is a parameter drilledDashboardPrefix in config.j file within js folder for this plugin. By default it has value "_drill_" and it means that menu option to setup jump to will appear only if there are any dashboards with this prefix defined. Either add this prefix to dashboards that you want to jump into, or change this parameter to "" string and then you should see menu option and all dashboards. Hope it helps.
-
Not sure if anyone else is having, or had, a similar issue. I recently updated to 6.6 and I lost the jump to selection in my option drop down. My widgets that I created prior to the upgrade still work fine, and the option is listed. Any ideas?
I figured it out. Real stupid error on my part. The target dashboard had a different cube, so there were no dashboards to jump to.
-
If you’re implementing the Jump to Dashboard plugin in a Pivot widget, you might notice that the pivot cells turn into hyperlinks with a default blue underlined font. You can remove the hyperlink formatting and change the style of the Pivot cells, by using the script below:
widget.on('ready', function(se, ev){
setTimeout(function(){
$('.p-value a',element)
.css({'color': 'red' , 'text-decoration':'none'}) // change styling
},500);
})
-
Is there a way to use separate set of filters for the main dashboard and the target dashboard?
My problem is when I am using JumpToDashboard plugin, the filters on the target dashboard are getting replaced with the filters on my main dashboard. Tried to use includeFilterDims parameter, but using this I can add only those filters which are already present in the main dashboard, not new ones. There are few filters I would like to add only at the target dashboard level which I don't want to include in the main dashboard.
-
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.
-
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.
-
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.
-
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 -
I found why I couldn't assign dashboards through the menu option any more -- the behavior of the prefix detection is different. Now it actually needs to be a prefix... (I had the prefix set to be a underscore, one being present in a dashboard name used to suffice). With the prefix set to none I can assign dashboards to my heart's content.
It would be nice if, when the option to show the folder name in the selection menu is active, the dashboards could be sorted alphabetically by foldername (or even generally, alphabetically by dashboardname). Now they seem to be sorted by dashboardId (or something -- I can detect no true pattern) with lots of drilldashboards, finding the right one can become very inconvenient.
In addition, something I'm not sure is a bug or a feature but it's something I'm noticing because I'm experimenting more with JTD at the moment -- *only* the filters from the parent dashboard (and/or widget) are set on the jump dashboard, erasing the filters that were already on there even if the parent dashboard doesn't do anything with them. I don't think that used to happen, but even if it did -- is there a way to preserve those filters? I don't want to put them all on the parent widget (if I even can)
(7.4.0 with most recent JTD)
-
Hi Alon
Is there a plan to have it support scatter plots in the future? We were previously using the plugin provided at https://support.sisense.com/entries/60285470-Drill-to-Pop-Up-Dashboard and it worked with scatter plots.
Cassandra
-
Hi Alon
I have realized that when you have a widget that has a filter the same as the dashboard filter the filter cancels itself out causing the pop up widget to filter incorrectly. For example if you have completed date of "2015" selected as a widget filter and completed date of "include all" as a dashboard filter when you select "Jump to dashboard" the widget will show data with any completed date rather than just data from 2015.
-
Hi Alon,
here you go. I've just noticed it happens only in Design Mode(overlap), in Viewer Mode overlap does not happen, but icon is still stretched.
1.png -
Thanks Michal !
This issue was known and was mentioned in the introduction section.
Please update your image plugin , the old image plugin caused this smear.
If this still persists, let me know.
Thanks
-
I'm having an issue where the right-click option shows sometimes, but not all. I have the same issue when editing the widget and attaching a _drill_ dashboard to it. Sometimes I have the option to assign it, others I don't. It seems that if I refresh the entire page it comes back, otherwise its hidden.
-
Hi Ryan,
On which widget does this happen ? please note that on indicators you should click on the number itself, clicking on the white space / title wont bring the option to jump.
In addition, you can define for an indicator the option to "left click" it (as if it was a URL) in order to activate the jump, change the drillToDashboardNavigateType parameter in the indicator to 3.
Let me know if that works out for you
Alon
-
It seems that disabling the drill-into (https://support.sisense.com/entries/60281100-Disable-Drill-into-) is negatively affecting this widget. When I include the disable-drill-into logic in a widget script it can (not always) hide the jump to dashboard option as well.
Please sign in to leave a comment.
Comments
124 comments