Customizing Widget Return Text

Hi Jack_Machesky ,

This will depend on the widget type.

For a BloX Control, i'd work on changing the result prior to rendering the widget in the processresult event.

const panelTitlesToAffect = ['Region', 'panel2']

widget.on('processresult', (w, args) => {
	// args.result looks like:
	// [{
	// { panel: 'panel1Title', value: 'panel1value11'}, 
	// { panel: 'panel2Title', value: 'panel2value1'}, 
	// ...}]
	const l = args.result.length

	// for each row in the returned data
	for (let i = 0; i < l; i++) {
		let row = args.result[i]

		// for each cell in the returned data
		for (const key in row) {
			let cell = row[key]

			// if the cell panel is one of the titles defined in panelTitlesToAffect 
			// then do something (in this case, check the cell Value and change the text)
			if (!panelTitlesToAffect.includes(cell.Panel)) { continue }
			if (cell.Value === 'True') {
				cell.Text = 'Yes'
			}
			if (cell.Value === 'False') {
				cell.Text = 'No'
			}
		}
	}
})

The code above establishes firstly the 'Panel Titles to target', and then manipulates the args.result data for the panels specified.

The logic you'll be able to change based on what result you'd like to see, but overall the above will change values of True and False from Panels Region and panel2 to display as Yes and No.

Hello Jack_Machesky,

If you are comfortable with a bit of JavaScript you should be able to use the Pivot 2.0 API to do this. Here is the documentation on it. https://sisense.dev/guides/customJs/jsApiRef/widgetClass/pivot2.html

If that's not something you're comfortable with please let us know and we can continue to help.

Hello Jack_Machesky ,

I wanted to follow up to see if the solution offered by rapidbisupport worked for you

If so, please click the 'Accept as Solution' button so that other users with the same questions can find the answer faster. If not, please let us know so that we can continue to help.

Thank you.