Case Statement at Widget Editor Level

[gwolfe]

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 what I need) won't work . The second will. I don't want to add this to the cube I am using as this is a one off use case. Thanks in advance

[harikm007]

Hi @gwolfe ,

If you need to replace 'Utah' with 'Current State', add the field 'State' as a Row and use script to replace it:

Pivot2 : https://community.sisense.com/t5/build-analytics/pivot2-replace-a-value-in-a-specific-value-in-anoth...

Pivot 1: https://community.sisense.com/t5/knowledge/replace-values-with-text-pivot-table-widget/ta-p/886

-Hari

[gwolfe]

@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'
				
		}

    }
);