Clickable URL links in Pivot rows

Please refer to this Community post for simplified instructions:
Render HTML In Pivot Table

__________________________________________________________________

Introduction

In this post we'll learn how to modify URLs placed in rows of a Pivot table into clickable links.

Purpose & Benefits

This will allow you to jump to either internal or external web resources for further information regarding a certain element.

Steps

1. Create a pivot table

2. Introduce a dimension of URLs into the pivot's rows element.

3. Copy the following script and paste it into the pivot's script:

Note: This code was updated for the latest Sisense version.

widget.on('domready', function(scope, args) {
 var pivots = $('dashboard widget.columnar');
 for (k=0; k < pivots.length; k++) {
  if ($('dashboard widget.columnar')[k].attributes.widgetid.value === scope.oid) {
      var rows = $('TD');
      for (i=0; i<rows.length; i++) {
    var text = $($('TD', $('dashboard widget.columnar')[k])[i]).text();
    $($('TD', $('dashboard widget.columnar')[k])[i]).html(text)
      }
  }
 }
})

Notes:

1. This feature does not support infinite scroll, which means that you will have to switch to paging.

1. If you'd like to have these links refer the user to an external page on the Internet, simply add 'http://' before all links in the actual data. This can easily be done by creating a new custom column in the table which holds the URLs and concatenate() 'http://' to the existing URL using the concatenate('string1', 'string2') function.

2. For a table widget (regular table or table with aggregation):
(This can be used for a pivot table as well)

Create a field in the EC containing the following, and use it as-is in the table widget:

'<a href="' + '<fixed url>'+ <EC Field> + '" target="_blank">' + <Field Name to appear in the table> + '</a>' AS Field

Update: July 2019

There is a simpler script by Artem Y to achieve this. From this community post.

widget.on('ready', function(){
     var tags = $('tbody span:contains("<")');
     for(var i = 0; i<tags.length; i++){
         $(tags[i]).replaceWith(String(tags[i].textContent))
     }
});

Eloy Meira May 28, 2019 13:39

We found the resolution that was to load the variable with proper encoding so the http server would recognize the url accordingly.

Katie Garrison July 03, 2019 19:39

Please also reference this Community post by Artem Y for a script that works on Sisense Versions 7.2 - 7.4+

Render HTML In Pivot Table

Vikas Sharma September 23, 2019 01:27

In my case this hyperlinks are only working on the first page and when changing page of table then not appearing, please suggest what can be the reason.

Clickable URL links in Pivot rows

Comments

Didn't find what you were looking for?