Break by sorting in stacked column chart | Help and How-To

jinendrarathod · 2025-03-03T06:20:01.064000Z

Please can you guide how we can sort by break by like here 1st chart 'in' should be shown as bottom in stacked then in with risk,out with upside and then out currently it is showing reversely.Also in 2nd chart how do we sort by stages to show qualification,then solution development,proposal and then contract negotiation.I searched community and tried below script which works for column and categories 1. Stage sorting working with column and stage in categories script - var categories= ['Qualification', 'Solution Development', 'Proposal', 'Contract Negotiation'];widget.on('processresult', function (_, ev) {console.log(ev) if (ev.rawResult.headers[0] === 'Opp stage') { ev.result.series.forEach(function (breakBy) { breakBy.data.sort( (a, b) => (categories.indexOf(a.selectionData[0]) - categories.indexOf(b.selectionData[0]))); }); ev.result.xAxis.categories = categories; }}); 2. Below script works for categories and when modified by break by it shows no valueswidget.on('processresult', function(widget, result) {// Ensure necessary data existsif (!result.result || !result.result.series || !result.result.xAxis || !result.result.xAxis.categories) {console.error("Missing necessary data in the result.");return;}// Define the desired stage orderconst stageOrder = ['Qualification','Solution Development','Proposal','Contract Negotiation','Closed Won'];// Initialize a placeholder for the reordered dataresult.result.xAxis.categories = stageOrder;// Reorder data within each series based on the stage orderresult.result.series.forEach(function(series) {// Check each data point's structureseries.data.forEach(dataPoint => {console.log('DataPoint:', dataPoint);});const reorderedData = stageOrder.map(stage => {// Log the current stage and search attemptconsole.log('Checking stage:', stage);// Find the matching data point for the current stageconst matchingDataPoint = series.data.find(dataPoint => {console.log('DataPoint selectionData:', dataPoint.selectionData); // Debugging linereturn dataPoint.selectionData && dataPoint.selectionData[0] === stage;});// Ensure the stage is mapped correctly, use `y: 0` if no data existsreturn matchingDataPoint || { y: 0, selectionData: [stage] };});// Log the reordered dataconsole.log("Reordered Data:", reorderedData);// Replace the series data with the correctly ordered dataseries.data = reorderedData;});// Validate values to ensure correct totals per stageresult.result.series.forEach(series => {let total = 0;series.data.forEach(dataPoint => {total += dataPoint.y; // Accumulate values});console.log(`Total for series ${series.name}:`, total);});// Debug output for verificationconsole.log("Final Processed Result:", JSON.stringify(result.result, null, 2));});

MoreDiscussions

Break by sorting in stacked column chart | Help and How-To | Sisense Community