Switch Multiple Rows In Pivot (As Viewer)
Updated 02-20-2024
Greetings.
wizsoft rhajlaoui
Due to changesMade method update, kindly ask you to change action code added in Part 1 to the following:
if (payload.data.selectVal != 0) {
// for selections that don't clear the columns
var dimIndex = payload.data.selectVal - 1;
var dimToSwapTo = payload.widget.metadata.panels[0].items[dimIndex];
var widgetIds = payload.data.widgetToModify;
var colToSwapIndex = payload.data.colToSwap - 1;
payload.widget.dashboard.widgets.$$widgets
.filter(i => widgetIds.includes(i.oid))
.forEach(function (widget) {
widget.metadata.panels[0].items[colToSwapIndex] = dimToSwapTo;
widget.changesMade('BloX', ['metadata']);
widget.refresh();
})
} else {
// for selections that do clear the columns
var colToSwap = payload.data.colToSwap;
var widgetIds = payload.data.widgetToModify;
payload.widget.dashboard.widgets.$$widgets
.filter(i => widgetIds.includes(i.oid))
.forEach(function (widget) {
widget.metadata.panels[0].items.length = colToSwap - 1;
widget.changesMade('BloX', ['metadata']);
widget.refresh();
})
}
Kindly ask you to inform on the result.
Best regards,
Illia