Additional Data Chart Tooltip Plugin
Download: Additional Info Tooltip
Introduction
The Additional Data Chart Tooltip Plugin Allows the user to display several values on one column chart and while making it easy on the eye. The purpose is to display several related values in one chart in a simple and easy way.
The Additional Data Chart Tooltip Plugin works on V 5.7. and up.
Example
In this example we choose 4 values and display the third and fourth values as additional info in the tooltip.
This is how the graph looks like before using the plugin:
And this is how the graph looks like after using the plugin:
.
We narrowed it down to 2 columns. The most important data appears on the graph and the additional info appears info for the two other columns appears in the tooltip while standing on the column. The First value is the value of the column we are standing on and the values below are the values we chose as additional data.
Steps
The Additional Data Chart Tooltip Plugin can be used with Column chart widget only.
In order to add an Additional Data Chart Tooltip Plugin to a chart, please follow the listed steps below:
Step 1:
Download and extract the enclosed folder into the plugins folder:
C:\Program Files\Sisense\PrismWeb\plugins\AdditionalInfoTooltip, if the "plugins" folder is not there, please create it. If you are using version 7.2 and higher unzip the contents into your C:\Program Files\Sisense\app\plugins\ folder.
Step 2:
Create a Column Chart. in the Values add both the data you want to display in the columns and the data you want to appear as additional data in the tooltip.
Go to the widget editor and edit the widget script
Step 3:
In order to use Additional Info Chart Plugin copy the script below and change the range [2,3] according to the values you wish to display in the tooltip.
prism.additionalInfoTooltip (widget, {seriesIndexes:[2,3],displayCurrentSelection:true});
Code configuration:
The Series Indexes numbers start from 0. The first value location is [0] , the second is [1] etc.
Put the location of the values you wish to display as additional info in the tooltip in the [] and separate them by comma. for example seriesIndexes:[2,3] will display the thirs and fourth values in the tooltip.
The default preferences is to display the values of the column value first and then the additional value. In order to hide current column from the tooltip just change the “displayCurrentSelection” value from true to false.
Press SAVE
Close the Script window
Step 4:
Refresh the Widget and click apply
The chart should appear with the columns chosen and tooltip configuration.
Plugin updated on May 17, 2017
- added support for values formatting
Plugin updated on Sep 18, 2017
- issue with selections don't affect the filter - fixed
Plugin updated on June 06, 2018
- added support for pie chart widgets.
- fixed v 7.1 compatibility issues
-
Hey Inbal, is there a way to make this work with a break by? I only have one value but multiple items in my break by. I'm using a line chart and the lines of the break by overlap each other a lot and I can only view one of my categories. Is it possible to add a tooltip to show me the value of all items in my break by for a specific point on my x-axis(date)?
Regards,
Chris
-
I implemented this, but it's messing up my Y axis. The Y axis has the formatting set to display in K's (ie, 50K , 100K) however, the 2 tooltip measures are set to display percentages. The Y axis in turn is ignorning what's set on its measure and showing in whole numbers (ie, 50,000, 100,000, etc) . Is there a fix or workaround for this?
Please sign in to leave a comment.
Comments
38 comments