Forum Discussion

zohebakber's avatar
zohebakber
Cloud Apps
01-09-2023
Solved

manual sorting categories in Scatter Chart

Hi Team, I want to manually sort the categories for the x axis in scatter chart. Please help. Thanks
Dashboards & Reporting
  • zohebakber's avatar
    zohebakber
    01-09-2023

    Hi Sijo,

    Thanks for the reply..
    I tried the below script and it worked..

     

    var categories= ['10+% lower','5-10% lower','2-5% lower','0-2% lower','0%','0-2% Higher','2-5% Higher','5-10% Higher','10+% Higher'];

    widget.on('queryend',function(se,ev){
    ev.rawResult.values.sort(function(a, b){
    var aIndex = categories.indexOf(a[0].data.trim());
    var bIndex = categories.indexOf(b[0].data.trim());

    if (aIndex < bIndex)
    return -1;
    if (aIndex > bIndex)
    return 1;

    return 0;
    })
    })

Sijo1995's avatar
Sijo1995
Cloud Apps
01-09-2023

Hi zohebakber ,

Please try this script

var xOrder = 'asc' //also, this value can be desc
var yOrder = 'asc'

widget.on('beforeviewloaded', function(scope, args) {
    var shouldBeExecuted = (order === 'desc' || order === 'asc' )
    if (args.widget.type !== 'chart/scatter' || !shouldBeExecuted) {
        return
    }

    var daysOrder = args.options.xAxis.categories.sort();
    if (xOrder === 'desc') {
        daysOrder.reverse()   
    }


    if (daysOrder.length === args.options.xAxis.categories.length) {
        args.options.xAxis.categories = daysOrder
        for (i=0; i<daysOrder.length; i++) {
            for (k=0; k<args.options.series.length; k++) {
                for (j=0; j<args.options.series[k].data.length; j++) {                    
                    if (args.options.series[k].data[j].selectionData[0] === daysOrder[i]) {
                        args.options.series[k].data[j].x = i;
                    }
                }
            }
        }
    }
})


widget.on('beforequery', function(se, ev) {
    ev.query.metadata.forEach(function(m) {
        if (m.wpanel && m.wpanel === 'y-axis') {
            m.jaql.sort = yOrder
        }
    })
})

 

Thanks

Sijo

zohebakber's avatar
zohebakber
Cloud Apps
01-09-2023

Hi Sijo,

Thanks for the reply..
I tried the below script and it worked..

 

var categories= ['10+% lower','5-10% lower','2-5% lower','0-2% lower','0%','0-2% Higher','2-5% Higher','5-10% Higher','10+% Higher'];

widget.on('queryend',function(se,ev){
ev.rawResult.values.sort(function(a, b){
var aIndex = categories.indexOf(a[0].data.trim());
var bIndex = categories.indexOf(b[0].data.trim());

if (aIndex < bIndex)
return -1;
if (aIndex > bIndex)
return 1;

return 0;
})
})