IPivotPareto.RowsSettings

Fore Syntax

RowsSettings: IPivotParetoSettings;

Fore.NET Syntax

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

Description

The RowsSettings property returns 80/20 analysis parameters, set by rows.

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;
    RowsSetting: IPivotParetoSettings;
Begin
    Eax := UiErAnalyzer1.Instance As IEaxAnalyzer;
    Pivot := Eax.Pivot;
    Pareto := Pivot.Pareto;
    //By rows
    RowsSetting := Pareto.RowsSettings;
    RowsSetting.ElementIndex := 0;
    RowsSetting.Kind := PivotParetoKind.Sum;
    RowsSetting.DisplayMax := False;
    RowsSetting.Threshold := 100;
    RowsSetting.Enabled := True;
End Sub Button1OnClick;

Clicking the button by the data of the first row applies 80/20 analysis. The analysis picks minimum values with the sum not greater than 100.

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;
    RowsSetting: IPivotParetoSettings;
Begin
    Eax := UiErAnalyzerNet1.AnalyzerUi.Instance As IEaxAnalyzer;
    Pivot := Eax.Pivot;
    Pareto := Pivot.Pareto;
    //By rows
    RowsSetting := Pareto.RowsSettings;
    RowsSetting.ElementIndex := 0;
    RowsSetting.Kind := PivotParetoKind.ppkSum;
    RowsSetting.DisplayMax := False;
    RowsSetting.Threshold := 10;
    RowsSetting.Enabled := True;
End Sub;

Clicking the button by the data of the first row applies 80/20 analysis. The analysis picks minimum values with the sum not greater than 100.

See also:

IPivotPareto