Difference between revisions of "Testing Article1"

From OnePager Documentation
Jump to: navigation, search
(Split Resources in the Chart)
 
(479 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Overview==
+
==Introduction==
  
There are situations and environments where OnePager Express is used to represent '''timespans''' that are short periods during which '''work periods''' are possibly divided between''' working times''' and '''non-working times'''.  The '''Working Hours and Non-Working Hours '''feature in OnePager provides a capability to display '''timespans''' in the chart that represent '''time periods''' where work is not being performed and where work is performed.  '''Non-working timespans '''take the visual form of '''colored''' '''Curtains''' in the '''graph''' as illustrated below:
+
This article is focused on using the ''' Column Splitting''' feature with OnePager Bundle '''Standalone''' and '''imported''' Asana '''source plans'''.
  
<center>[[File:X70-22_5_4-70-(1)-11252020.png]]</center>
+
==About Splitting and Parsing Fields==
<!--<center>X70-22_5_4-70-(1)-11252020.png</center>-->
+
  
Above, the '''Non-Working Hours''' are shown in blue for '''timespans '''from midnight to 8:00 AM, the lunch hour, and from 5:00 PM to midnight.  The controls for this feature are available in the '''Chart Properties ''' form '''Time Axis '''tab '''Format '''sub-tab in the '''Days of the Week and Non-Working Times '''group’s '''Working Hours: '''sub-group as shown below:
+
The OnePager '''column splitting''' feature allows you to '''duplicate task bars''' when a task in your Asana '''source plan''' is assigned to '''multiple resources''' (or anything else).  Because assignments from Asana often are '''comma-delimited''', this feature enables OnePager to '''parse the comma-delimited list''' and '''create a unique task bar''' for each instance in the '''comma-separated''' list. 
  
<center>[[File:X70-22_5_4-70-(2)-11252020.png]]</center>
+
===Split Resource Names Example===
<!--<center>X70-22_5_4-70-(2)-11252020.png</center>-->
+
  
The '''Template Properties '''form '''Time Axis '''tab’s '''Format '''sub-tab has identical controls where you can manage '''Working and Non-Working Hours''' at a '''global '''level.  You can access the '''Set Working Times '''form for defining '''Working Hours '''by clicking the '''Define Working Hours…''' button as illustrated below:
+
Say you want to use '''color-codes''' on task bars/milestone symbols based upon your Asana '''source plan’s Assigned to''' column as shown below:
  
<center>[[File:X70-22_5_4-70-(3)-11252020.png]]</center>
+
<center>[[File:P72-24_5_3-72-(1)-11022023.png]]</center>
<!--<center>X70-22_5_4-70-(3)-11252020.png</center>-->
+
<center>P72-24_5_3-72-(1)-11022023.png</center>
  
Once you establish your '''Working Hour '''periods in the '''Set Working Times''' form, the '''Non-Working Hours''' checkbox is available to display these '''non-working time periods''' as '''colored Curtains''' in the chartIn the '''Working Hours:''' sub-group are the controls for '''showing/hiding Non-Working Hours''' and a Standard '''Color Chooser '''dropdown button for setting the '''color''' for '''Non-Working Hour Curtains'''.  The intent of this article is to provide the information essential for you to '''create''', '''edit''', and '''manage Working and Non-Working Hour time periods''' in the chart.
+
Some of the entries in the '''Assigned to''' column consist of multiple, '''comma-separated''' items and some tasks only used one '''resource'''.  Without the '''column splitting''' feature, a chart '''created''' from these data and assigned task bar/milestone symbol '''colors''' based upon the '''Assigned to''' column looks like this:
  
==Accessing the Working Hours and Non-Working Hours Feature==
+
<center>[[File:P72-24_5_3-72-(5)-11272023.png]]</center>
 +
<center>P72-24_5_3-72-(5)-11272023.png</center>
  
The '''Working Hours and Non-Working Hours '''feature is accessible from the '''Chart Properties '''form and the '''Template Properties '''formDefining '''Working Hours '''in the '''Template Properties '''form allows you to define '''Working Hours''' and use them in any chart created using that specific '''Template'''.  Defining '''Working Hours '''in the '''Chart Properties '''form allows you to define '''Working Hours '''and use them in charts created with that specific '''Chart Properties '''form and in any follow on snapshots that might be created subsequently.  '''Chart Properties '''forms that contain '''Working Hours '''definitions can be '''saved''' as '''Template Properties '''forms for future use and to standardize '''Working Hours '''definitions throughout the organization.
+
OnePager, in this case, treats the '''entire string''' as an individual '''Assigned to''' valueTo provide more flexibility in displaying task bars that have '''multiple resources''' assigned, OnePager supports the concept of a '''column splitting'''.  This feature recognizes '''comma-separated''' values in a '''designated column''' and '''creates a separate task bar''' for each of the '''comma-separated''' values.
  
===Using the Chart Properties Form to Define Working and Non-Working Hours===
+
===Enabling Splitting===
  
You can access the controls for '''managing Working and Non-Working Hours''' by accessing the '''Chart Properties '''form '''Time Axis '''tab’s '''Format '''sub-tab in the '''Days of the Week and Non-Working Hours''' group of controls and the '''Working Hours: '''sub-group as shown below:
+
To use this feature requires turning '''ON''' the feature in the Asana '''Template Properties''' form you intend to use to make the chart.  The setting must be turned '''ON''' before the chart is created so launch OnePager Bundle from the '''desktop icon''', click the '''NEW''' button on the '''OnePager Bundle Start''' form to access the '''OnePager choices''' form, '''select''' your Asana '''source plan''', and type in the chart's '''title''' as shown here:
  
<center>[[File:X70-22_5_4-70-(2)-11252020.png]]</center>
+
<center>[[File:P72-24_5_3-72-(2A)-11022023.png]]</center>
<!--<center>X70-22_5_4-70-(2)-11252020.png</center>-->
+
<center>P72-24_5_3-72-(2A)-11022023.png</center>
  
Clicking the '''Define Working Hours… '''button accesses the '''Set Working Times '''form with the '''default settings''' as shown below:
+
When you click the '''Next>''' button at the bottom of the form, OnePager accesses the second page of the '''OnePager choices''' form shown below:
  
<center>[[File:X70-22_5_4-70-(4)-11252020.png]]</center>
+
<center>[[File:P72-24_5_3-72-(2AA)-11022023.png]]</center>
<!--<center>X70-22_5_4-70-(4)-11252020.png</center>-->
+
<center>P72-24_5_3-72-(2AA)-11022023.png</center>
  
The '''default settings''' shown in the form above sets Monday through Friday as the default '''working days'''.  The '''Work Time Start '''and '''Work Time End''' are set to 8:00 AM and 5:00 PM respectively.   
+
Clicking the '''Edit current template''' button accesses the current '''Template Properties''' formNavigate to the '''Field Mappings''' tab on the form, check the '''Enable splitting on:''' checkbox to '''ON''' and (in this example) select the '''Assigned To''' column from the dropdown list providedThe results are shown here:
  
You have the option of specifying the '''Time format: '''either as a 24 Hour or 12 Hour format depending on your selection of the appropriate radio button.
+
<center>[[File:P72-24_5_3-72-(2AAA)-11022023.png]]</center>
 +
<center>P72-24_5_3-72-(2AAA)-11022023.png</center>
  
The controls in the '''Set Working Times '''form are covered below.
+
Click the '''Save and use''' button to complete the process and close the current '''Template Properties''' form returning you to the second page of the '''OnePager choices''' form show above.
  
====Select Day(s): Option Control====
+
===Split Resources in the Chart===
  
Making a selection of the '''days of the week''' to apply '''Working Hours''' is done by using the mouse left-click to select an individual day.  You can select a series of individual days by using the '''CTL+Left-Click '''operation.    Hold down the '''CTL key''' and use the mouse left-click to select more than one '''day of the week'''You can also select a continuous series of day by using the '''SHIFT+Left-Click '''operation.  Hold down the '''SHIFT key''' and click the first '''day of the week '''in the sequence and follow by continuing to hold down the '''SHIFT key''' and use the mouse left-click to select the last '''day of the week '''in your sequence.
+
Clicking the '''Create new chart''' button completes the process and creates the chart with the '''column splitting''' feature in use.  The chart with '''splitting''' looks like this:
  
====Set Working Times for Selected Day(s): ====
+
<center>[[File:P72-24_5_3-72-(2)-11022023.png]]</center>
 +
<center>P72-24_5_3-72-(2)-11022023.png</center>
  
After making the selection for '''days of the week''', the second step is to establish the '''Work Time Start''' and '''Work Time End''' settings.  You have the option to establish more than one set of '''Start/End''' settings by using the '''Add '''buttonEach '''Start''' and '''End''' dropdown provides time options in increments of '''15 minutes'''.  Use each '''Start/End''' dropdown to set the respective required '''Work Start''' and '''Work End '''timesOnce the '''Start/End '''times are set, either use the '''Add '''button to make another entry or click the '''OK '''button to finish the operation.
+
In the chart with '''column splitting''' shown above, there are now several more task bars in the '''Chart Editor''' than there were before.  The task bar for '''Plate Movement''' is now '''split into two (2) separate task bars''', one for each of the '''two resources assigned'''.  The task bar for '''Centrifugal Barrier''' is now '''split into three (3) separate task bars''', one for each of the '''three resources''' that were assigned to this task in the Asana '''source plan'''.  Each of the '''resources''' has a unique '''color''' assignedEach of the '''resources''' appears by itself in the '''Legend'''.  The '''Legend title''' shows the '''column name''' that is used for '''splitting the columns'''.
  
===Using the Template Properties Form to Define Working and Non-Working Hours===
+
With this feature, you can use '''column splitting''' just like any other column by using the dropdowns in the '''Template Properties''' form or '''Chart Properties''' form to assign '''colors, highlight task bars and milestone symbols, and to define and label rows and swimlanes'''.
  
The '''Template Properties '''form '''Time Axis '''tab’s '''Format '''sub-tab is identical to the corresponding sub-tab in the '''Chart Properties '''form.  The process for defining '''Working Hours and Non-Working Hours''' described for the '''Chart Properties '''form is the same for the '''Template Properties''' form.  As mentioned above, '''Working Hours and Non-Working Hours''' defined in the '''Chart Properties '''form can be made into '''Template Properties '''forms by '''saving''' the '''Chart Properties '''form as a '''Template Properties '''form. 
+
==Splitting Resources and Task Links==
  
For more information on '''Managing the Current Template''', please see this section in the article at:  [[Managing the Current Template for Version 7.0#Making a Template Properties Form from a Chart | Managing the Current Template – Making a Template Properties Form from a Chart]] <!--24.6.1-70-->
+
When task bars with '''Data-Driven''' or manual '''Task Links''' are '''split''', the '''Task Links''' ('''Data-Driven''' and manual) are '''not shown'''.  Further, the '''Task Links''' that are now '''hidden''' and '''do not''' have entries in the '''Where are My Links?''' form.
 
+
'''Working Hours and Non-Working Hours''' defined in a '''Chart Properties '''form can also be '''edited '''for future use in subsequent snapshots.  However, '''edits''' made in the '''Chart Properties '''form to '''Working Hours and Non-Working Hours''' do not change the information residing in the basic '''Template '''form used to create the initial chart.
+
 
+
For more information on the '''Template''' form's '''Time Axis''' tab, please see this section in the article at: [[Template Only Features for Version 7.0 (OnePager Express)#Template Properties Form's Time Axis Tab | Template Only Features-OnePager Express – Template Properties Form's Time Axis Tab]] <!--24.2.1-70-->
+
 
+
==Defining Working Hours  - An Example==
+
 
+
The following is an example using the '''Working Hours and Non-Working Hours '''feature:
+
 
+
===Setting Up The Working Hours Example===
+
 
+
To establish '''Working Hours '''for the chart, click the '''Define Working Hours…''' button as discussed above.  Clicking the '''Define Working Hours…''' button accesses the '''Set Working Times''' form shown below:
+
 
+
<center>[[File:X70-22_5_4-70-(5)-11252020.png]]</center>
+
<!--<center>X70-22_5_4-70-(5)-11252020.png</center>-->
+
 
+
The form above is shown with Monday through Friday pre-selected so that the pre-defined '''Work Time Start''' and '''Work Time End''' settings are show in the '''Set working times for selected day(s): '''window.  You can '''select''' more than one day of the week and your entries in the adjacent window apply to all these days.  Within '''selected days''' you are able to enter more than one set of '''Work Time Start''' and '''Work Time End''' sets.  This is particularly useful when there are multiple '''shift work schedules'''.
+
 
+
Clicking the '''Add''' button below the window places a '''blank entry''' where you can use the '''Time Selector '''dropdowns to make '''time of day '''selections.  The '''Time Selector''' dropdown list provides '''time of day '''selections at '''15 minute''' intervals beginning at '''12:00 AM''' ('''00:00 hours''' for '''24 hour''' representations) and ending at '''midnight''' ('''24:00 hour''' for '''24 hour''' representations).
+
 
+
The '''Delete''' button removes a selected entry from the window.  Instructions are provided in the area below the '''Add''' and '''Delete '''buttons.  As mentioned above, you have the option with the '''Time format: '''control to select between '''24 Hour''' and '''12 Hour''' representations of time in the '''Set working times for selected day(s): '''window.  When all entries are made, click the '''OK '''button to complete the definition and the '''Apply '''or '''OK '''button on the '''Chart Properties '''form to apply the formats to the chart.
+
 
+
===Creating The Working Hours For The Example===
+
 
+
As an example, suppose you want to '''define working hours''' as Monday through Friday from 8:00 AM to 5:00 PM with a '''one hour lunch period''' from 12:00 PM to 1:00 PM. After accessing the '''Set Working Times '''form, you might do the following.  First make the five day selections in the '''Select day(s): '''window so it looks like this:
+
 
+
<center>[[File:X70-22_5_4-70-(5)-11252020.png]]</center>
+
<!--<center>X70-22_5_4-70-(5)-11252020.png</center>-->
+
 
+
You can use the '''CTL+Left-Click''' to select several days of the week one at a time or use the '''SHIFT+Left-Click''' to select a range of days.  Shown above is the single predefined '''Working Time''' for a typical five-day work week.    Since you want to represent the '''time period''' between 12:00 PM and 1:00 PM as the '''Non-Working Time''' lunch period, you need to modify the first entry above so that the '''Work Time End''' value is 12:00 PM.  This is done by clicking on the '''Time Picker '''dropdown and selected the desired '''work time '''from the list as shown below:
+
 
+
<center>[[File:X70-22_5_4-70-(6)-11252020.png]]</center>
+
<!--<center>X70-22_5_4-70-(6)-11252020.png</center>-->
+
 
+
Once the first '''edit''' above is made, you need to '''Add''' another entry to define the afternoon '''work  hours''' from 1:00 PM to 5:00 PM as shown below using the individual '''Time Pickers''' to make the '''time of day '''selections:
+
 
+
<center>[[File:X70-22_5_4-70-(7)-11252020.png]]</center>
+
<!--<center>X70-22_5_4-70-(7)-11252020.png</center>-->
+
 
+
When this is done, click the '''OK '''button on the form and the desired '''Working Hours '''are entered.  If we take a segment of the chart used in this document and establish it with '''Time Axis Levels '''of '''Years''', '''Quarters''', and '''Days of the Week''', it looks like this:
+
 
+
<center>[[File:X70-22_5_4-70-(8)-11252020.png]]</center>
+
<!--<center>X70-22_5_4-70-(8)-11252020.png</center>-->
+
 
+
If we set up the '''Working Hours and Non-Working Hours''' to equate to a standard work day, the '''Set Working Times '''form looks like this:
+
 
+
<center>[[File:X70-22_5_4-70-(7)-11252020.png]]</center>
+
<!--<center>X70-22_5_4-70-(7)-11252020.png</center>-->
+
 
+
When you click '''OK '''on the above form you are taken back to the '''Chart Properties '''form where the next step is to select the '''color''' for the '''Non-Working Hours''' by clicking the Standard '''Color Chooser '''dropdown as shown below:
+
 
+
<center>[[File:X70-22_5_4-70-(9)-11252020.png]]</center>
+
<!--<center>X70-22_5_4-70-(9)-11252020.png</center>-->
+
 
+
The light green '''color '''is selected from the Standard '''Color Chooser''' and becomes the '''color''' of the '''Curtains''' introduced into the chart across the day '''timespans '''to indicate the portion of the day that represents '''Non-Working Hours''' as shown in the chart below:
+
 
+
<center>[[File:X70-22_5_4-70-(10)-11252020.png]]</center>
+
<!--<center>X70-22_5_4-70-(10)-11252020.png</center>-->
+
 
+
The above chart displays '''Non-Working Hours''' when the '''Show Non-Working Hours''' checkbox is checked '''ON'''.  Unchecking the '''Show Non-Working Hours '''checkbox to '''OFF''' '''hides''' all '''Non-Working Hour timespans''' and shrinks the '''width '''of the chart because these '''timespans '''are '''hidden'''.  Such a chart looks like this after the right edge of the chart is widened to the right:
+
 
+
<center>[[File:X70-22_5_4-70-(11)-11252020.png]]</center>
+
<!--<center>X70-22_5_4-70-(11)-11252020.png</center>-->
+
 
+
Above, Saturdays and Sundays are '''hidden''' as are '''Non-Working Hour''' portions of the five day work week.  With '''Non-Working Hours hidden''', the days of the week are represented above with uniform '''widths'''.
+
 
+
===Restoring Default Working Hour Settings===
+
 
+
The recommended method to restore a chart to the '''default settings '''is to remove unwanted '''timespans''' for '''Non-Working Hours'''.  To do this, go back to the '''Set Working Times '''form through the '''Chart Properties '''form access method and revert to a single entry with the '''default working hours''' for Monday through Friday. Click the '''OK''' button on the form when this action is completed.
+
 
+
Next, access the Standard '''Color Chooser''' and reset the '''color''' by clicking the '''No Fill '''checkbox in the Standard '''Color Chooser''' form.  Make sure that the '''Show Non-Working Hours '''checkbox is checked '''ON'''.  Last, click '''Apply/OK''' on the '''Chart Properties '''form.
+
 
+
==The Honor Non-Working Time Feature==
+
 
+
The '''Honor Non-Working Time '''feature is an advanced feature provided in OnePager Express so that you can accurately display '''%Complete''' bars in your charts that adapted to match the '''%Complete''' bars in Microsoft Excel '''source plans''' when you configure the chart with appropriate '''Working '''and '''Non-Working Time'''.
+
 
+
Specifying precise '''Working Hours '''and '''Non-Working Hours''' has an impact on how OnePager Express expresses '''Percent Complete''' ('''%Complete''') when you decide to '''Honor non-working time '''in the calculations.  This '''advanced feature''' assures that you can apply '''Non-Working Hours''' to the '''graph''' and have OnePager Express accurately reflect the '''percent complete''' information from your '''source plan'''.  You have the capability to select whether you want to take into account '''source plan''' '''Working Hours''' or '''Elapsed Time''' as is the case with previous versions of OnePager.
+
 
+
===Controls for Honoring Non-Working Time===
+
 
+
If you specifically define '''Working '''and '''Non-Working Hours''' precisely you can tell OnePager Express to '''Honor non-working time''' by checking the checkbox in the '''Set percent-complete properties '''form accessed from the '''Chart Properties '''form '''Task Bars '''tab by clicking the '''%Complete Properties''' button as shown in the illustration below:
+
 
+
<center>[[File:X70-22_5_4-70-(14)-11252020.png]]</center>
+
<!--<center>X70-22_5_4-70-(14)-11252020.png</center>-->
+
 
+
The '''Honor non-working time '''checkbox is shown above in the checked''' '''or '''ON''' setting.  The '''Honor non-working time '''checkbox is '''NOT '''provided in the '''Set percent-complete properties''' form for '''Milestone symbols.'''  The '''Template '''form '''Task Bars''' tab '''Task Bar Decorations '''control group’s '''%Complete Properties… '''button provides access to the '''Template '''form’s '''Set percent-complete properties''' form where its '''Honor non-working hours '''checkbox is located.
+
 
+
===Honoring Non-Working Time - An Example===
+
 
+
As an example, suppose you have a simple Microsoft Excel '''source plan '''that has five task bars with the '''%Complete''' information as shown below:
+
 
+
<center>[[File:X70-22_5_4-70-(12)-11252020.png]]</center>
+
<!--<center>X70-22_5_4-70-(12)-11252020.png</center>-->
+
 
+
If you create a standard chart from the above '''source plan '''it looks like this:
+
 
+
<center>'''Honor Non-Working Time Checkbox is Off'''</center>
+
<center>[[File:X70-22_5_4-70-(13)-11252020.png]]</center>
+
<!--<center>X70-22_5_4-70-(13)-11252020.png</center>-->
+
 
+
In the chart above, the '''Honor non-working time''' checkbox is unchecked or '''OFF'''.  This means that OnePager Express does '''not''' take into consideration any of the '''Non-Working Time '''information you provided in the '''Set Working Times '''form to display '''%Complete''' information.  To show the change when '''Non-Working Time''' information is specified, suppose you establish rules in the '''Set Working Times''' form that show '''working times''' from 8:00 AM to Noon and from 1:00 PM to 5:00 PM for Monday through Friday as shown below:
+
 
+
<center>[[File:X70-22_5_4-70-(16)-11252020.png]]</center>
+
<!--<center>X70-22_5_4-70-(16)-11252020.png</center>-->
+
 
+
After clicking the '''OK''' button on the form above and the '''Apply''' button on the '''Chart Properties''' form, go back to the '''Task Bars''' tab on the '''Chart Properties''' form and access the '''Set percent-complete properties '''form as you did before and check the '''Honor non-working time''' checkbox to '''ON'''.  This step is completed when you click '''OK '''on the '''Set percent-complete properties''' form and the '''Apply''' or '''OK''' buttons on the '''Chart Properties '''form.  The last step required is to do a snapshot '''Replace All''' by going to the OnePager Express '''Data''' ribbon tool bar tab and clicking the '''Replace Snapshot '''button.  After the '''Replace Snapshot '''operation is complete,''' '''the chart looks like this:
+
 
+
<center>'''Honor Non-Working Time Checkbox is On'''</center>
+
<center>[[File:X70-22_5_4-70-(15)-11252020.png]]</center>
+
<!--<center>X70-22_5_4-70-(15)-11252020.png</center>-->
+
 
+
The differences can be emphasized more if the two illustrations are placed in a before and after arrangement as shown below:
+
 
+
<center>'''Honor Non-Working Time Checkbox is Off'''</center>
+
<center>[[File:X70-22_5_4-70-(13)-11252020.png]]</center>
+
<!--<center>X70-22_5_4-70-(13)-11252020.png</center>-->
+
 
+
<center>'''Honor Non-Working Time Checkbox is On'''</center>
+
<center>[[File:X70-22_5_4-70-(15)-11252020.png]]</center>
+
<!--<center>X70-22_5_4-70-(15)-11252020.png</center>-->
+
 
+
The result from looking at the two charts above, is that when '''Non-Working Time''' is displayed for '''%Complete''' bars they appear shorter when '''Non-Working Time''' is precisely defined''' '''and the '''Honor Non-Working Time '''checkbox is checked '''ON'''. This is because in the second chart above, no work is performed between 12 noon and 1:00 PM or from 5:00 PM to 8:00 AM the next day.  Since the example above used the '''Standard Calendar''' in Microsoft Project, the '''graph '''above with the '''Honor Non-Working Time '''checkbox checked''' On''' is exactly like the Microsoft Project Gantt chart shown here.
+
 
+
<center>[[File:X70-22_5_4-70-(17)-11252020.png]]</center>
+
<!--<center>X70-22_5_4-70-(17)-11252020.png</center>-->
+
  
 
==Related Links==
 
==Related Links==
  
[[Template Only Features for Version 7.0 (OnePager Express) | Template Only Features-OnePager Express]] <!--24.2.1-70-->
+
{| class="wikitable"
 
+
| [[Templates versus Charts for Version 7.2 | Templates versus Charts]] 4.0.1.3-72
[[Managing the Current Template for Version 7.0 | Managing the Current Template]] <!--24.6.1-70-->
+
| [[Linking Task and Milestones Using Manual and Data-Driven Task Links for Version 7.2 | Linking Task and Milestone Using Manual and Data-Driven Task Links (Portal)]] 19.0.1-72
 +
|-
 +
| [[Editing with the Chart Properties form for Version 7.2 (Portal) | Editing with the Chart Properties form (Portal)]] 21.0.1-72
 +
| [[Template Only Features for OnePager Pro for Version 7.2 | Template Only Features for OnePager Pro]] 24.1.1-72
 +
|-
 +
| [[Template Only Features for OnePager Express for Version 7.2 | Template Only Features for OnePager Express]] 24.2.1-72
 +
| [[Template Only Features for Primavera P6 Source Plans in OnePager Version 7.2 | Template Only Features for Primavera P6 Source Plans in OnePager]] 24.2.2-72
 +
|-
 +
| [[Template Only Features for Smartsheet Source Plans in OnePager Version 7.2 | Template Only Features for Smartsheet Source Plans in OnePager]] 24.2.3-72
 +
| [[Splitting and Parsing Columns for OnePager Pro for Version 7.2 | Splitting and Parsing Fields for OnePager Pro]] 24.4.1-72
 +
|-
 +
| [[Splitting and Parsing Columns for OnePager Express for Version 7.2 | Splitting and Parsing Fields for OnePager Express]] 24.5.1-72
 +
| [[Splitting and Parsing Columns for Primavera P6 Source Plans in OnePager Version 7.2 | Splitting and Parsing Columns for Primavera P6 Source Plans in OnePager]] 24.5.2-72
 +
|-
 +
| [[Splitting and Parsing Columns for Smartsheet Source Plans in OnePager Version 7.2 | Splitting and Parsing Columns for Smartsheet Source Plans in OnePager]] 24.5.3-72
 +
| [[Splitting and Parsing Columns for Project for the Web Source Plans for Version 7.2 | Splitting and Parsing Columns for Project for the Web Source Plans]] 24.5.5-72
 +
|-
 +
| [[Splitting and Parsing Columns for Planisware Enterprise Source Plans for Version 7.2 | Splitting and Parsing Columns for Planisware Enterprise Source Plans]] 24.5.7-72
 +
| [[Splitting and Parsing Columns for Wrike in OnePager Version 7.2 | Splitting and Parsing Columns for Wrike in OnePager]] 24.5.11-72
 +
|}
  
(22.5.4-70)
+
(24.5.9-72)
  
[[Category:Version 7.0]]
+
[[Category:Version 7.2]]
[[Category:OnePager Express]]
+
 
[[Category:Editing the Chart]]
 
[[Category:Editing the Chart]]
 +
[[Category:Task/Milestone Editing]]
 +
[[Category:Column Splitting]]
 
[[Category:Charts]]
 
[[Category:Charts]]
[[Category:Time Axis]]
+
[[Category:Task Links]]
[[Category:Time Axis Tab]]
+
[[Category:Working Times]]
+
[[Category:Non-Working Times]]
+
[[Category:Color Palettes]]
+
[[Category:Curtains]]
+
 
[[Category:Ribbon]]
 
[[Category:Ribbon]]
 
[[Category:Snapshots]]
 
[[Category:Snapshots]]
[[Category:Task/Milestone]]
+
[[Category:Template Properties Form]]
[[Category:Percent Complete]]
+
[[Category:Chart Properties Form]]
[[Category:Template]]
+
[[Category:Asana]]
[[Category:Chart Properties]]
+
[[Category:OnePager Bundle]]

Latest revision as of 20:52, 27 November 2023

Introduction

This article is focused on using the Column Splitting feature with OnePager Bundle Standalone and imported Asana source plans.

About Splitting and Parsing Fields

The OnePager column splitting feature allows you to duplicate task bars when a task in your Asana source plan is assigned to multiple resources (or anything else). Because assignments from Asana often are comma-delimited, this feature enables OnePager to parse the comma-delimited list and create a unique task bar for each instance in the comma-separated list.

Split Resource Names Example

Say you want to use color-codes on task bars/milestone symbols based upon your Asana source plan’s Assigned to column as shown below:

P72-24 5 3-72-(1)-11022023.png
P72-24_5_3-72-(1)-11022023.png

Some of the entries in the Assigned to column consist of multiple, comma-separated items and some tasks only used one resource. Without the column splitting feature, a chart created from these data and assigned task bar/milestone symbol colors based upon the Assigned to column looks like this:

P72-24 5 3-72-(5)-11272023.png
P72-24_5_3-72-(5)-11272023.png

OnePager, in this case, treats the entire string as an individual Assigned to value. To provide more flexibility in displaying task bars that have multiple resources assigned, OnePager supports the concept of a column splitting. This feature recognizes comma-separated values in a designated column and creates a separate task bar for each of the comma-separated values.

Enabling Splitting

To use this feature requires turning ON the feature in the Asana Template Properties form you intend to use to make the chart. The setting must be turned ON before the chart is created so launch OnePager Bundle from the desktop icon, click the NEW button on the OnePager Bundle Start form to access the OnePager choices form, select your Asana source plan, and type in the chart's title as shown here:

P72-24 5 3-72-(2A)-11022023.png
P72-24_5_3-72-(2A)-11022023.png

When you click the Next> button at the bottom of the form, OnePager accesses the second page of the OnePager choices form shown below:

P72-24 5 3-72-(2AA)-11022023.png
P72-24_5_3-72-(2AA)-11022023.png

Clicking the Edit current template button accesses the current Template Properties form. Navigate to the Field Mappings tab on the form, check the Enable splitting on: checkbox to ON and (in this example) select the Assigned To column from the dropdown list provided. The results are shown here:

P72-24 5 3-72-(2AAA)-11022023.png
P72-24_5_3-72-(2AAA)-11022023.png

Click the Save and use button to complete the process and close the current Template Properties form returning you to the second page of the OnePager choices form show above.

Split Resources in the Chart

Clicking the Create new chart button completes the process and creates the chart with the column splitting feature in use. The chart with splitting looks like this:

P72-24 5 3-72-(2)-11022023.png
P72-24_5_3-72-(2)-11022023.png

In the chart with column splitting shown above, there are now several more task bars in the Chart Editor than there were before. The task bar for Plate Movement is now split into two (2) separate task bars, one for each of the two resources assigned. The task bar for Centrifugal Barrier is now split into three (3) separate task bars, one for each of the three resources that were assigned to this task in the Asana source plan. Each of the resources has a unique color assigned. Each of the resources appears by itself in the Legend. The Legend title shows the column name that is used for splitting the columns.

With this feature, you can use column splitting just like any other column by using the dropdowns in the Template Properties form or Chart Properties form to assign colors, highlight task bars and milestone symbols, and to define and label rows and swimlanes.

Splitting Resources and Task Links

When task bars with Data-Driven or manual Task Links are split, the Task Links (Data-Driven and manual) are not shown. Further, the Task Links that are now hidden and do not have entries in the Where are My Links? form.

Related Links

Templates versus Charts 4.0.1.3-72 Linking Task and Milestone Using Manual and Data-Driven Task Links (Portal) 19.0.1-72
Editing with the Chart Properties form (Portal) 21.0.1-72 Template Only Features for OnePager Pro 24.1.1-72
Template Only Features for OnePager Express 24.2.1-72 Template Only Features for Primavera P6 Source Plans in OnePager 24.2.2-72
Template Only Features for Smartsheet Source Plans in OnePager 24.2.3-72 Splitting and Parsing Fields for OnePager Pro 24.4.1-72
Splitting and Parsing Fields for OnePager Express 24.5.1-72 Splitting and Parsing Columns for Primavera P6 Source Plans in OnePager 24.5.2-72
Splitting and Parsing Columns for Smartsheet Source Plans in OnePager 24.5.3-72 Splitting and Parsing Columns for Project for the Web Source Plans 24.5.5-72
Splitting and Parsing Columns for Planisware Enterprise Source Plans 24.5.7-72 Splitting and Parsing Columns for Wrike in OnePager 24.5.11-72

(24.5.9-72)