[email protected] +1.303.779.0344

Displaying Statistical Functions in Text Columns

When building a OnePager chart in a Gantt chart layout, text columns will display the value of each individual task in the chart. In a timeline layout, however, there can be multiple tasks per row, so text columns must make use of statistical functions to correctly display the aggregate data for each set of tasks in a given row.

For example, here is a OnePager Gantt chart with a text column for cost. Because there is only one task in each row, the text column shows the cost of each individual task:

Gantt chart showing the cost of each task in the project

When switching to a timeline layout, you may want to pick a statistical function for each row so that OnePager will know how to compute the correct value. In this example, we will show the total cost for each phase. To do this, go to Home > Chart Properties > Task Bars and switch the Task Layout from to a Timeline. Then, in the settings for the Text Column check the box next to Function and choose Sum:

Sum the costs of all tasks in a given row of a project timeline.

Statistical functions in text columns are only available when your chart is in a timeline layout; these controls are disabled for Gantt charts since there is no need to compute statistics when there is only one task per row.

After clicking OK, OnePager will place multiple tasks in each row and total the costs of each task:

Project timeline with sum of task costs.

Available Functions

OnePager supports multiple statistical functions, which vary based on the type of field in the text column.

Numeric and date/time fields support the following statistics:

  • Minimum
  • Maximum
  • Average (Mean)
  • Median
  • Mode
  • Sum

Text (string) fields support the following statistics:

  • First (Alpha)
  • Last (Alpha)
  • Mode

Related Articles

Displaying Additional Fields in Text Columns
Symbol Columns (Stoplight Charts)


Last Updated: November 20, 2023