IPivotPareto.ColumnsSettings

Fore Syntax

Fore.NET Syntax

ColumnsSettings: Prognoz.Platform.Interop.Pivot.IPivotParetoSettings;

Description

The ColumnsSettings property returns 80/20 analysis parameters, set by columns.

Fore Example

Executing the example requires a form with the Button1 button, the UiErAnalyzer component named UiErAnalyzer1 and the TabSheetBox component that is used to display data.

Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);
Var
    Eax: IEaxAnalyzer;
    Pivot: IPivot;
    Pareto: IPivotPareto;
    ColumnsSetting: IPivotParetoSettings;
Begin
    Eax := UiErAnalyzer1.Instance As IEaxAnalyzer;
    Pivot := Eax.Pivot;
    Pareto := Pivot.Pareto;
    //By columns
    ColumnsSetting := Pareto.ColumnsSettings;
    ColumnsSetting.ElementIndex := 0;
    ColumnsSetting.Kind := PivotParetoKind.Percent;
    ColumnsSetting.DisplayMax := True;
    ColumnsSetting.Threshold := 3 / 10;
    ColumnsSetting.Enabled := True;
End Sub Button1OnClick;

Clicking the button by the data of the first column applies the 80/20 analysis. The analysis picks 30% of maximum values.

Fore.NET Example

Executing the example requires a .NET form with the Button1 button, the UiErAnalyzerNet component named UiErAnalyzerNet1 and the TabSheetBoxNet component that is used to display data.

Imports Prognoz.Platform.Forms.Net;
Imports Prognoz.Platform.Interop.Express;
Imports Prognoz.Platform.Interop.Pivot;

Private Sub button1_Click(sender: System.Object; e: System.EventArgs);
Var
    Eax: IEaxAnalyzer;
    Pivot: IPivot;
    Pareto: IPivotPareto;
    ColumnsSetting: IPivotParetoSettings;
Begin
    Eax := UiErAnalyzerNet1.AnalyzerUi.Instance As IEaxAnalyzer;
    Pivot := Eax.Pivot;
    Pareto := Pivot.Pareto;
    //By columns
    ColumnsSetting := Pareto.ColumnsSettings;
    ColumnsSetting.ElementIndex := 0;
    ColumnsSetting.Kind := PivotParetoKind.ppkPercent;
    ColumnsSetting.DisplayMax := True;
    ColumnsSetting.Threshold := 3 / 10;
    ColumnsSetting.Enabled := True;
End Sub;

Clicking the button by the data of the first column applies 80/20 analysis. The analysis picks 30% of maximum values.