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
-
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 Sagi,
That's strange; you should be able to search for some at least.
Do you maybe have adblocker or scriptblocker addons in your browser? I remember those used to give me issues sharing dashboards.
Otherwise, is your dashboard perhaps on a different data source that no users have rights to yet?
Iris
-
Hi,
I'm encountering an issue in Internet Explorer 11 where the jump to dashboard doesn't even load. I see the pop-up window when I trigger the jump to, but no content loads. I just a see a white/blank window. I'm currently running Sisense version 8.0.1. and I have jump to plugin 1.0.27 installed.
Thanks,
Paul Lam
-
You could use our Dashboard Tabber
If you create the tabber on the 'drilled-to' target dashboard, you can then toggle between the various dashboards while inheriting the filter scope, contact us for a live demo!
QBeeQ - Sisense Partner of the Year 2019
-
We have encountered an issue with the plugin where it breaks if the parent dashboard has a filter based on a calculation.
To recreate the issue:
- In the parent dashboard, create a value C using a formula, i.e. A/B
- Create a value filter of the above value, i.e. C > 0
- Create a JTD dashboard and connect it to the parent dashboard
- The new JTD dashboard works initially; however, breaks as soon as the parent dashboard adds filters to it
- Tested it using the latest (and previous) version
cc: Elizabeth Wang
-
Hello,
We've recently upgraded to Version: 8.2.2.10066. The JTD that was working fine, is no longer showing the list of Jump To Dashboards that are available.
- I have some named _drill and some as _drill_
- Most are in the same folder as the dashboards/widgets that are calling them.
- all are using the same elasticube
- I've tried editing the config file to turn off the requirement for having the same elasticube. I did rename the menu wording to ensure that the updates took place. They did.
- The Menu Option shows up, no drill dashboards show up in the list.
Thanks, Mike
-
We've had this issue in one of our environments last week and we spent some time trying to fix it.
We've tried restarting the Plugin Service, restart all the other services, disable and then re-enable the plugin to no avail.
What has worked, however, is reinstalling the plugin with the latest version, even if it is the same one:
- Backup or note the Jump To Dashboard global settings
- Delete the Jump To Dashboard plugin from the plugins directory
- Download the new zip
- Unzip it into the plugins directory
- Modify the plugins settings, if necessary
-
Pivot table jump-to-dashboard links are broken, using JTD 1.2.17 on Sisense 8.2.3, having just upgraded from 7.2.
Clicking on one of the links results in a javascript console error:
app-main.js?g=d185316586d67d7b3d0bbdf2d3d6eb32:1142 Uncaught TypeError: Cannot read property 'replace' of null
at v (app-main.js?g=d185316586d67d7b3d0bbdf2d3d6eb32:1142)
at HTMLTableCellElement.f (app-main.js?g=d185316586d67d7b3d0bbdf2d3d6eb32:1142)
at HTMLTableCellElement.dispatch (common.js?g=d185316586d67d7b3d0bbdf2d3d6eb32:51)
at HTMLTableCellElement.g.handle (common.js?g=d185316586d67d7b3d0bbdf2d3d6eb32:51)If I use Chrome dev tools to pretty-print and breakpoint that line of code, I get:
var u = s.getAttribute("measurePath").replace(/\"/g, '\\"');
And `s` has value
<td id="pivot__C0" class="p-grand-total-head p-first-data-col" fidx="1" isnull="true">…</td>
and, sure enough, s.getAttribute("measurePath") returns null (and s.getAttribute("fidx") returns "1").
This happens even when the plugins directory is renamed and the latest version of JTD (1.2.17) is downloaded and extracted to the newly-created-and-empty plugins directory.
Any ideas?
Please sign in to leave a comment.
Comments
132 comments