Parent Level Calculations

How are the metrics of parent bar calculated:

  1. Start Date - Earliest start date of all its child bars

  2. End Date - Latest end date of all its child bars

  3. Progress - Refer to the below explanation:

Parent bar progress is the sum of its every child bar's product of duration and progress, divided by the sum of all its child bars duration:

Image 1: Parent bat progress
  • d is the duration of child bar

  • p is the progress of the child bar

Example:

Image 2: Example
  1. Data label (numeric) - Select the aggregation in Number formatting -> Data_label_column_name Aggregation Type option. It provides a dropdown to select the aggregation for numeric values in data labels.

    1. Sum=ΣdSum= Σd

    2. Average=Σdl/nAverage= Σdl/n

    3. Parent bar data label of weighted average type is the sum of its every child bar's product of duration and data label value, divided by the sum of all its child bars duration.WeightedAverage=(Σ(dxdl))/ΣdWeighted Average = (Σ(d x dl))/Σd

Where n is number of child bars, d is the duration of child bar, dl is the data label value of the child bar.

Read about: Aggregation Type

Last updated

Was this helpful?