cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
Sometimes you might want to change the color of your pivot columns based on a condition - for example coloring the column in green if the cell's value is equal to a specific word and red if not:
STEP 1 - ADD THE FOLLOWING SCRIPT TO YOUR PIVOT'S EDIT SCRIPT
var columns = [2, 3]; //select the date columns that should be transformed
var colors = ['green','red']; //color when true, color when false
condition_value = 'Africa' //set to the desired condition value

widget.on('ready', function(se, ev){
$.each(columns, function(index, value){
num = $("tbody tr:first").children().length - value;
var e = element;
var w = widget;
var d = dashboard;

$("tbody tr" , e).not('.wrapper, .p-head-content').each(function(){
var cell = $(this).children().last();
for (var a = 0; a < num; a++){
cell = cell.prev();
}

var cell_value = cell.text()
if (cell_value === condition_value) {
$(cell).css("background-color", colors[0]);
}
else{
$(cell).css("background-color", colors[1]);
}
});
});
});

STEP 2 - SET THE VALUES ABOVE THE LINE TO THE DESIRED VALUES

STEP 3 - SAVE THE SCRIPT, REFRESH THE WIDGET AND PRESS "APPLY"

Rate this article:
Version history
Last update:
‎03-02-2023 09:17 AM
Updated by:
Contributors