Forum Discussion

gwolfe's avatar
gwolfe
Data Pipeline
06-09-2022

Case Statement at Widget Editor Level

Hi,   I am trying to create a new dimension base off of a case statement in the widget editor, but I can't get it to work (unless it's based on a value).  For example, this first snippit (this is...
dashboards & reporting
gwolfe's avatar
gwolfe
Data Pipeline
06-09-2022

harikm007 Thanks for the help. These scripts appear to just change the name, but doesn't allow for grouping by "like" names. (Let me know if I am doing something wrong). In the example below, I would like all "Others" to be grouped into 1 row. 

 

widget.transformPivot(
    {
        type: ['member']
    },
    function setCellBackground(metadata, cell) {
        
		columnIndex = 0
		
		if(metadata.colIndex == columnIndex)
		{
			cell.style = cell.style || {};
		
			if(cell.content != 'UT')
				cell.content = 'Other'
				
		}

    }
);