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:
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:
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:
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:
- Average (Mean)
Text (string) fields support the following statistics:
- First (Alpha)
- Last (Alpha)
Last Updated: November 20, 2023