Embed Images to Pivot/Tables
*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 steps needed in order to create a pivot widget with images embedded into a column.
Steps
The following steps will walk through the process of adding an image into a pivot or table widget.
Step 1 - Add the Plugin
Download the attachment and unzip the contents into your C:\Program Files\Sisense\PrismWeb\plugins folder.
If the plugins folder doesn't exist, just create it. After those files have been unzipped there, you may also have to restart the web server.
Step 2 - Create a pivot or table widget
On your dashboard create a new table and add in the necessary rows, columns, and values from the Elasticube. Make sure to add in the field that contains the URL to your images under the Rows section. At the upper right corner of the widget editor, click the settings icon and look for the Image URL Column setting. This menu will list out all the dimensions that have been added under Rows, so just pick the one that has the URL to your images.
Step 3 - Apply the Changes
Click the green Apply button in the widget editor to get back to the main dashboard. You may need to refresh the page once more in order for the images to display.
Notes
- The image url must be defined within the Elasticube in order for this plugin to work. If your database does not have a field with this information, it can usually be created by using a Custom Field in your Elasticube table.
- The image url must be with http:// protocol
-
Since in current version images do not resize automatically just go to tableimages.js and edit this line (it is present twice so edit both) : var imgTag = "<div style='margin:0 auto;'><img src='" + $(this).text() + '"></img></div>"; to this var imgTag = "<div style='margin:0 auto;'><img src='" + $(this).text() + "' width='50' heigth='60'></img></div>"
-
Great plugins !
The only thing I miss is the ability to add the image as a "complement" not as a full row. But I guess this is mre a problem from pivot widget : if I add an image, the image will be seen as a "category" so sorting and ranking will not work anymore. But it is the same when you have more than 1 or 2 rows in a pivot ... Is there an excetption that can be made for a pivot ?
Attached is a screenshot of what I can have : a nice top3 of product sold for each shops, with the image. But if I ad the product reference + the image, I get all the product for each shops ...
Any solution ?
top3 by shop.png
with product name.png -
Hey guys,
1. Does anybody know how to use this plugin with more than one image column? (if I want to show a pivot table with images in 4 different columns, for instance).
2. I know I can set mannualy the image's width and height on tableimages.js, but is there a way to define this on a per widget basis? (I mean, one pivot table showing small images, and other showing large pictures).
Thanks!
Please sign in to leave a comment.
Comments
16 comments