Sisense has the ability to display an image by using the custom image widget that can be found here. While this is a very useful widget, this is only good for a static image.
Lets say you want to have an image that changes based on a filter. A use case for this might be a master dashboard for several companies where you would like to filter the dashboard based on company.
The following steps will walk through the process of adding the ability to add images into a pivot and formatting it so that it only displays the logo.
Step 1 - Create a table with the image location
Create a csv or excel file with the dimension name and the image you want to display and add it to your data model:
The logo location could be a URL or you can copy the images locally to your Sisense install directory under - "C:\Program Files\Sisense\PrismWeb\Resources\Images":
Step 2 - Create a pivot table with the column that contains the image location.
widget.on('ready', function(e, args)
var $lmnt = $(element);
if(x > 0)
var val = $(y).find('td span').innerHTML;
$(y).find('td span').innerHTML = '<img src="'+ val +'"></img>';
}) $('.p-head-content, .p-value',element)
.css('color','white') // change font color
Step 4 - Add a filter on the dimension column.
You now can switch dimensions and the image will change to reflect selected dimension:
Please sign in to leave a comment.