Adding downloadable links and images in a pivot table [Linux]

Reference: Sisense Community Article – “Clickable URL Links in Pivot Rows”

Step-by-Step Guide

1. Enable HTML Rendering for Pivot Tables

1. Navigate to Admin → System Management → Configuration.
   
   
2. In the Configuration Manager, select Pivot Table.
   
   
3. Enable Allow rendering Pivot Table content as HTML.
   
   
4. Scroll down and click Save.
   
   

This setting allows the Pivot widget to interpret HTML code inside table cells.

2. Host Your Files or Images

You can either:

• Store files/images directly on your Sisense server, or
  
  
• Use external URLs.
  
  

To host them in Sisense:

1. Go to Admin → App Configuration → File Management → branding.
   
   
2. Upload your files or images.
   

They will be accessible at:

http://<sisense-deployment>/branding/<file-name>.<extension>

3. Create a Custom Column with Your Download/ Image URLs

In your data model, create a new custom column (e.g., DownloadHTML) within a table containing the URLs you want to display or make downloadable.

 

 

 

4. Add HTML for Downloadable Links

To generate a clickable download link in the Pivot table, use the following example:

'<a href="' + [URLs] + '" download="' + [Name] + '">' + [Name] + '</a>'

• [URLs] = column containing the file download URL
  
  
• [Name] = column containing the download filename
  
  

This creates a clickable link that begins downloading the file immediately.

5. Add HTML for Clickable Images That Trigger Downloads

To embed an image that downloads when clicked, use the following example:

'<a href="' + [Link] + '" download="' + [Name] + '"><img src="' + [Link] + '" alt="' + [Name] + '" style="max-width:200px; height:auto;"></a>'

• Clicking the embedded image triggers the download.
  
  
• Adjust the max-width style as needed.
  

6. Rebuild the Cube

Rebuild your data model to ensure the new custom column becomes available in widgets.

7. Add the Column to a Pivot Table

Create or open a Pivot table and add the custom column you’ve created as a field.
Thanks to HTML rendering, the Pivot will display clickable links or images exactly as intended.

Conclusion

With HTML rendering enabled, you can embed downloadable links and clickable images directly inside Pivot tables - no widget scripts required. This provides a clean and user-friendly way to give users access to files, documents, and images right from within a dashboard.

Happy dashboarding!

References/Related Content 

Clickable URL Links in Pivot Rows

Disclaimer: This post outlines a potential custom workaround for a specific use case or provides instructions regarding a specific task. The solution may not work in all scenarios or Sisense versions, so we strongly recommend testing it in your environment before deployment. If you need further assistance with this, please let us know.

Verified on version: L2025.4.0.258