Negative displaying in the Pie Chart

[Mr_Henry_M]

Hello!

I have an infotable with the following data:

When displaying this data in the Pie Chart the second and third records are displayed in different colors:

Can this widget combine records with the same Label-field and color them in one color so that there are no such repetitions?

[Constantine · Accepted solution]

Hello,

I'm not sure about the widget, but in case it isn't possible, you can easily group it on the server side:

var result = Resources["InfoTableFunctions"].RenameField({
    t: Resources["InfoTableFunctions"].Aggregate({
        t: infotable,
        columns: "col2",
        aggregates: "SUM",
        groupByColumns: "col1"
    }), 
    from: 'SUM_col2',
    to: 'col2'
});

(Substitute infotable, col1 and col2 with correct names).

Regards,
Constantine

[Mr_Henry_M]

Thanks!