Forum Discussion

jfarmer's avatar
jfarmer
Cloud Apps
08-29-2022
Solved

Pivot 2.0 Javascript resizing strangely

Hello,

I have used the following javascript before to modify results within a column of a pivot table, but when I try to do the same for column table objects I get strange behavior. Here is the javascript I use to modify the pivot table. 

 

 

 

widget.on('ready', function(){
$('[class*="--row-1"] div.table-grid__content__inner').map(function(i, cell) { 
switch (cell.innerHTML ) {
case "1": cell.innerHTML='January';
break;
case "2": cell.innerHTML='February';
break;
case "3": cell.innerHTML='March';
break;
case "4": cell.innerHTML='April';
break;
case "5": cell.innerHTML='May';
break;
case "6": cell.innerHTML='June';
break;
case "7": cell.innerHTML='July';
break;
case "8": cell.innerHTML='August';
break;
case "9": cell.innerHTML='September';
break;
case "10": cell.innerHTML='October';
break;
case "11": cell.innerHTML='November';
break;
case "12": cell.innerHTML='December';
break;
}
}); 
})

 

 

 

 

This is the resulting table.

If after the widget loads I can click as if I wanted to change the sorting and the table refreshes and looks correct. After doing that it looks as follows. 

I am certain it is a simple problem, but was wondering if anyone could help me identify it. Thanks

Thanks!

  • Hi jfarmer ,

    Here is an alternate script to replace column title. Try if this resolves the problem:

    
    widget.transformPivot(
        {
            type: ['member']
        },
        function setColoredDot(metadata, cell) {
            cell.style = cell.style || {};
    
    		if(metadata.rowIndex == 1)
    		{
    			switch (cell.content) {
    				case "1": cell.content='January';
    				break;
    				case "2": cell.content='February';
    				break;
    				case "3": cell.content='March';
    				break;
    				case "4": cell.content='April';
    				break;
    				case "5": cell.content='May';
    				break;
    				case "6": cell.content='June';
    				break;
    				case "7": cell.content='July';
    				break;
    				case "8": cell.content='August';
    				break;
    				case "9": cell.content='September';
    				break;
    				case "10": cell.content='October';
    				break;
    				case "11": cell.content='November';
    				break;
    				case "12": cell.content='December';
    				break;
    			}
    		
    		}
    
    	}
    
        
    );
    

    -Hari

2 Replies

Replies have been turned off for this discussion
  • harikm007's avatar
    harikm007
    Data Warehouse

    Hi jfarmer ,

    Here is an alternate script to replace column title. Try if this resolves the problem:

    
    widget.transformPivot(
        {
            type: ['member']
        },
        function setColoredDot(metadata, cell) {
            cell.style = cell.style || {};
    
    		if(metadata.rowIndex == 1)
    		{
    			switch (cell.content) {
    				case "1": cell.content='January';
    				break;
    				case "2": cell.content='February';
    				break;
    				case "3": cell.content='March';
    				break;
    				case "4": cell.content='April';
    				break;
    				case "5": cell.content='May';
    				break;
    				case "6": cell.content='June';
    				break;
    				case "7": cell.content='July';
    				break;
    				case "8": cell.content='August';
    				break;
    				case "9": cell.content='September';
    				break;
    				case "10": cell.content='October';
    				break;
    				case "11": cell.content='November';
    				break;
    				case "12": cell.content='December';
    				break;
    			}
    		
    		}
    
    	}
    
        
    );
    

    -Hari