What’s new in OnePager 7.2: Statistical Columns

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:

  1. Percent Complete
  2. Cost
  3. Start Date
  4. 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.

This entry was posted in OnePager 7.2 by Safford. Bookmark the permalink.

About Safford

Safford is a versatile technology professional with a solid history of empowering emerging growth companies in a broad array of industries. His employment history includes energy industry consulting at Quorum Software, Senior Manager of Client Services and Technical Sales at telecom service aggregator GetConnected, and Vice President of Strategic Partner Management at electronic payment processor IP Commerce. Prior to his tenure as OnePager's COO, Safford was the company's Vice President of Marketing and Alliances. Safford holds a BA in Psychology and management from Rice University.

Leave a Reply

Your email address will not be published. Required fields are marked *