Additional Data Chart Tooltip Plugin

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

Subramanian CV March 13, 2020 04:46

Thanks . This is it I was looking for. Thought it would be a part of main sisense feature , which i would need help to find . Surprisingly this comes as a plugin

Chris Bridges March 30, 2020 16:26

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

Delsaran Bigglesworth April 08, 2020 17:46

Is it possible for this to effect the categories on a bar chart?

I would like to display some order numbers but keep my X axis a date.

An Y April 08, 2020 21:42

Anyone had luck making the plugin work with Break-by?

Chris Bridges June 03, 2020 18:42

Hi An Y,

I'm also hoping for a solution for the break by. I have not heard anything since asking a few months ago.

Marina Doria June 29, 2020 12:24

Hi,

Is there any way to have same functionality for an Indicator Widget. I have 86K, and I want a tooltip where I can see all the number, 86,254

Thank you!!

Sheetal Chima July 01, 2020 15:02

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?

Paul Furman September 24, 2020 16:20

It would be very useful to have this available for the table widgets.