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
-
@Michal, thanks, changing that setting allows all users to see the dashboards again. But, the linking functionality only works for the admin of the superdashboard.
Situation:
- drilledDashboardPrefix: ""
- hideDrilledDashboards: false
- drilledDashboardDisplayType: 1The rest of the settings are the default ones.
Then when the admin user clicks on an indicator widget, it opens a new tab with the url: http://[our_base_url]/app/main#/dashboards/566abe08830fae982f000009?volatile=false&folder=55508e487a750dd43800007f
But when a non-admin user clicks the same indicator widget, there're a 404 in the browser console, attached to this url: http://[our_base_url]/api/v1/dashboards/566abe08830fae982f000009So, what's happening?
Thanks,
Tim
-
@Michal, thanks for you answer.
Since we use 1 sisense user for all our employees and all dashboards are shared with that user, the user should be able to access these dashboards. At least, using the normal navigationbar on the left, the user can reach these dashboards. So that's not the issue.
-
I am seeing something similar to Mike on March 5, 2016.
We have a popup set on an indicator widget, and clicking it does pop up the dashboard, but it's slow to show data. When trying to close this popup, it appears that in fact multiple popups had opened on top of each other, with the topmost one loading last.
-
Hi,
I've tried to implement the jump to dashboard from an image widget, I've updated all the plugins.
now there are 2 events:
- click anywhere in the widget except the image triggers "jump to dashboard"
- click on the image triggers jump to the URL in the widget or to home if URL is blank..
Am I missing something?
thanks,
Eyal
-
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.
-
Has anyone gotten this to work for Sisense 6.5? We are using Version: 6.5.0.10362. After following the instructions on adding the plugin to the plugin folder, I am unable to see the option available in the menu for either an indicator widget nor a column chart as original examples portray. Please see the attached screenshots.
-
@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.
-
@Michael - Thanks for the tip! Yes, I actually did have my drill dashboard prefixed with the default "_drill_" prefix as mentioned. However, the issue was that the both the main dashboard and the one to drill to needed to be based on the same Elasticube. Fixed the issue and works like a charm!
-
But, for a Bar chart without selecting any field in Category section, it is not supporting the JumptoDashboard feature!!.
Any reason behind that?
When i am taking any field in Category section then it is supporting this feature.
But, I need this feature without touching Category section.
Please help on this.
Regards,
Ganesh
-
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.
-
Hi
I have a pivot table with few columns, and I am trying to jump or drill down to a different dashboards, is it possible?
If thats not possible, atleast can I disable the clickable link from other columns, and let the user be able to click from one column which will be appropriate for the drill down dashboard being designed?
Appreciate your time on this.
regds
-
Hi,
When I add script options to a widget, I can no longer access the menu for specifying the drill-to dashboard. If I remove the script, the option is back. This is Sisense 6.5 on Chrome.
Is this a known issue? Or is my script the problem?
prism.jumpToDashboard(widget,
{drilledDashboardDisplayType:2, displayDashboardsPane:false,
displayToolbarRow:false, displayHeaderRow:false,
drillToDashboardRightMenuCaption:"Jump to Revenue Center Detail",
displayFilterPane:false,drilledDashboardsFolderPrefix: "Drill"});Thanks,
Leslie
-
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.
-
I am trying to get this to work on multiple widgets on one page. For two of the widgets, a bar chart and a scatter plot, when I jump to the dashboard, the correct filters are getting set. In other words, if I select one bar or one circle, that particular set of rows are in the jump to dashboard. For the bar chart, the attribute is on the "Category", for the Scatter Plot, the attribute is in the "Break By".
However, on another widget that is a scatter plot, when I click on one circle, it appears that none of the filters are getting passed to the _drill_ dashboard because it returns all of the rows, not just the 1 represented in the scatter plot. In this widget, the attribute is in the "Point" and "X-Axis".
I do not have any custom JavaScript on any of the widgets.
Should I have any filters on my _drill_ dashboard? I have the same filters from the parent dashboard currently.
Any ideas on what I might be missing?
-
Edit: Issues resolved, got it working
Hi Im trying to remove all settings from the pop up window using the supplyed options, can I check that the js is added to the widget that you click on to generate the pop up?
prism.jumpToDashboard(widget, {drilledDashboardDisplayType:2,
displayFilterPane:false, displayDashboardsPane:dispfal
se, layToolbarRow:false, displayHeaderRow:false }); -
I'm currently having an issue where the option to select a _Drill_ dashboard is not appearing when I edit my widget. I have installed the latest and greatest and have 2 _Drill_ dashboards ready to go, however, I cannot set them to their related parent dashboard. Any help out there?
Please sign in to leave a comment.
Comments
132 comments