Previously, we looked at how to use statistical functions with conditional formatting to determine which symbols should appear in a column when there is more than one task in a single row. Statistical functions aren’t limited to symbol columns, though. In fact, beginning in OnePager 7.2, you can use a similar set of statistical functions to drive the text that appears in a column as well. We call these Statistical Columns.
Let’s return to our earlier example where we have a project with multiple phases and several tasks in each phase:
If we create a OnePager Gantt chart from this project, we’ve always been able to use Text Columns to display key pieces of data for each task, like this:
Here, we’ve used four of OnePager’s Text Columns to display:
- Percent Complete
- Start Date
- Finish Date
This works well in a Gantt chart layout, because each text column cell represents only one task. As soon as you collapse the Gantt Chart into a Timeline layout, each text column cell needs to display data for multiple tasks, not just one.
To remedy this, we can convert OnePager’s Text Columns to a Statistical Column. Under Chart Properties > Rows/Swimlanes, locate the Left #1 text column and check the Function box. Once checked, pick which Function you want to apply. In the case of Percent Complete, it makes the most sense to average the values of all of the tasks in the row, so we can pick the Average function:
Repeat this process for the remaining text columns, picking the most appropriate statistical function. Then, switch to a Timeline Layout and click OK. OnePager will compute the statistical function for each set of tasks and place the value into the Statistical Column, like this:
In this example, we’ve use Statistical Columns as follows:
- Left #1 uses the Average function to compute the average (mean) percent complete.
- Left #2 uses the Sum function to compute the total cost.
- Left #3 uses the Min function to compute the earliest start date.
- Left #4 uses the Max function to compute the latest finish date.
With Statistical Functions, you can combine timeline layouts and text columns, and have confidence that the data displayed accurately reflects all of the tasks in each row of your chart.