Knowledge Base Article

Replace Values with Text - Pivot Table Widget

Introduction The following enables to change the value in pivot tables to specific strings, while allowing the use of conditional coloring as normal. Step 1 - Add The Following Script To ...
Published 10-19-2021
Wojtek's avatar
Wojtek
Cloud Apps
06-22-2023

HI all,

Im on L2023.2 and this works for me:

widget.on('ready', function(){
$("div[class*='--col'] div.table-grid__content__inner").map(function(i, cell) { 
switch (cell.innerHTML ) {
case "-1": cell.innerHTML='PASS';
break;
case "-2": cell.innerHTML='WARNING' ;
break;
case "-3": cell.innerHTML='FAIL';
break;
default: cell.innerHTML=cell.innerHTML;
}
}) 
})

Hope this helps,

W

About Widget & Dashboard Scripts

Node avatar for Widget & Dashboard Scripts
200 ArticlesCreated: 6 months agoLatest Activity: 04-15-2025