Aggregate Line

Aggregate Line

The figure given below shows the Add Aggregate Line page.



The table given below describes different fields present on Add Aggregate Line page.

Section

Field

Description

Remark

Line

Name

It allows you to select a name for the Aggregate Line.

·       Select a proper name that is convenient to remember.

·       It is a mandatory field.

Scope

It allows you to select the aggregation scope when X-split, Y-split, or both are applied to the widget.

·       You can select any one of the following scopes

o   Entire View

o   Cell

·       When none of the splits is applied,

o   Entire View is the default scope option.

·       In Entire View, the line is considered for the entire Measure selected while plotting the widget.

o   For example, the Aggregate Line is drawn considering the average of the quantity.

·       In the Cell option, the data is aggregated for each cell of the widget.

o   For example, in the figure: Fixed Line for Line Y-axis in Combination Charts, a reference line is drawn using a Median of the Minimum of Sales for each Segment within the Category.

Measure

It allows you to select the variable/feature to be aggregated.

·       You can select any one of the variables from the drop-down.

Aggregation

It allows you to select an aggregation method.

This method generates a value corresponding to which the line is plotted.

·       You can select any of the following methods

o   Mean

o   Median

o   Maximum

o   Minimum

o   Sum

o   Percentile

It is a mandatory field.

Thickness

It allows you to select the line thickness.

The minimum and maximum values for thickness are 3 and 20, respectively.

Color

It allows you to select the line color.

By default, the color is black.

Transparency

It allows you to select the line shading concentration.

·       The minimum and maximum values for concentration are 0% and 100%, respectively.

·       The 0% value indicates the lightest shade, and 100% indicates the darkest shade for the line color.

·       The default Transparency for the line shading is 50%.

Line Style

It allows you to select the line appearance.

·       You can select any one of the following three types of appearances.

o   Dashed

o   Dotted

o   Solid

·       By default, the dotted line style is applied to the Aggregate Line.

Display

It allows you to select the line placement.

·       You can select to place the line at the

o   Back or

o   Front

of the plotted widget

·       By default, the reference line is placed at the Back of the widget.

Data Label

Label

It allows you to select the content displayed along with the line.

·       You can select any one of the following labels.

o   Value

o   Custom Text

·       When you select the value, it automatically appears in the field next to Label. This field is not editable.

·       When you select Custom Text, you can insert relevant text in the field next to Label, to be displayed with the line.

·       You can make the Label bold, italic, and underline it.

Font

It allows you to select the Label font.

You can select any one of the following font types:

·       Monospace (default)

·       Raleway

·       Roboto

·       Calibri

·       Times New Roman

·       Segoe UI

Size

It allows you to select the Label font size.

The minimum and maximum font sizes applicable are one (1) and 1638, respectively.

Color

It allows you to select the Label color.

By default, the color is light black.

Horizontal Align

It allows you to place the Label horizontally concerning the line.

·       You can align the Label horizontally at the Left, Centre, and Right of the Fixed Line.

·       By default, the Label is always horizontally aligned to the Left.

Vertical Align

It allows you to place the Label vertically concerning the line.

·       You can align the Label vertically Above the Line, On the Line, and Below the Line.

·       By default, the Label is always vertically aligned Above the line.

Background Color

It allows you to select the color for the background.

By default, the color is white.

Border Color

It allows you to border the region in which the Label is displayed.

By default, the color is white.

Display Units

It allows you to select the multiples of units in which the value is measured.

 

 

·       You can select any of the following units

o   Default

o   None

o   Thousand

o   Lakhs

o   Millions

o   Billions

o   Trillions

·       Default indicates that the unit is assigned automatically by parsing the value.

·       None represents that no unit is set for the value.

Decimal Places

It allows you to select the number of decimal places up to which you want to display the Label value.

The minimum and the maximum number of decimal places allowed are one (1) and nine (9), respectively.


(info)
Notes:

  • You can choose to switch on or off the Data Label field. By default, the Data Label field is switched on. You can switch it off by clicking the toggle button next to the Data Label heading.
  • You can set the selections to default by clicking Reset To Default (next to the Add/Update button).
  • Click Add to insert the Analytics line in the widget.

To insert an Aggregate line, first plot a Column Chart using the dimensions and measures from the dataset.

For example, we plot a Column Chart of the Average of Sales by Category.

By default, no reference line is displayed. The Line toggle is switched Off.



We configure the Fixed and Aggregate Lines by changing the Line and Data Label field parameters.

For the Aggregate Line,

  • Select the Median as the Aggregation method
  • Select the Scope as Entire View

The resultant widget is shown below.



If you select the Cell view as Scope (instead of Entire View) and Display as Front, then the resultant widget is shown below.



Now, on the same chart, if you apply an X-split using the Region dimension, and select Partition as the Scope view, then the resultant widget is obtained as shown below.



Similarly, in the case of Combination Charts, you can plot the Analytics Lines for both Column Y-axis and Line Y-axis.

The figure below shows a Combination Chart for Sales against Maximum Profit with Country as the Line Legend. A Fixed Analytics Line corresponding to the Line Y-axis (Maximum Profit) is plotted at a value of 450.


    • Related Articles

    • Fixed Line

      The figure given below shows the Add Fixed Line page. The table given below describes different fields present on Add Fixed Line page. Section Field Description Remark Line Name It allows you to select a name for the Fixed Line. · Select a proper ...
    • Analytics ( Reference) Line

      An Analytics (Reference) Line corresponds to a particular value on the X or Y axis regarding the widget plotted. Notes: An analytics line is used to draw in any widget that contains at least one of the two axes, for example, Column Chart, Pareto ...
    • Line Style

      Line Style feature allows you to customize the appearance of the lines in the widgets. It helps you to tailor the visualizations to meet your specific needs and preferences. This feature is available in the following widgets: Line, Pareto, ...
    • Grid Line

      Gridlines are a crisscross mesh of lines drawn in the region between X and Y axes in a graph or chart. The table given below describes different fields present on Grid Line formatting on Y-axis. Field Description Remark Width It allows you to select ...
    • Grid Line

      Gridlines are a crisscross mesh of lines drawn in the region between X and Y axes in a graph or chart. The table given below describes different fields present on Grid Line formatting on X-axis. Field Description Remark Width It allows you to select ...