Difference between revisions of "Testing Article1"

From OnePager Documentation
Jump to: navigation, search
(→‎The OnePager Express Where Are My Links? Form)
(→‎Split Resources in the Chart)
 
(463 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
==Rules for Importing Data-Driven Task Links – Template  Properties Form Rules==
+
==Introduction==
  
−
The requirements for '''importing Data-drive Task Links''' '''before''' a chart is created are discussed in this article along with rules for '''showing Data-Driven Task Links''' in the chart.
+
This article is focused on using the ''' Column Splitting''' feature with OnePager Bundle '''Standalone''' and '''imported''' Asana '''source plans'''.
  
−
The '''“Master”''' switch in the OnePager Express '''Template Properties '''form '''Task Link '''tab’s '''Show task links''' checkbox must be checked '''ON''' as shown here:
+
==About Splitting and Parsing Fields==
  
−
<center>[[File:X70-19_1_3_2-70-(1)-10072020.png]]</center>
+
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>X70-19_1_3_2-70-(1)-10072020.png</center>-->
+
  
−
The '''default''' setting for the '''Show task links''' checkbox is checked or '''ON'''.  If this checkbox is unchecked or '''OFF, Data-driven Task Links '''cannot be '''imported '''and manual '''Task Links '''cannot be created or '''shown'''.  In order to '''import Data-driven Task Links''' when a chart is being '''created''', the '''Import predecessors''' checkbox located in the '''Data-Driven Task Links '''control group of the above '''Template Properties '''form’s '''Task Links''' tab must also be checked '''ON''' as shown below:
+
===Split Resource Names Example===
  
−
<center>[[File:X70-19_1_3_2-70-(2)-10072020.png]]</center>
+
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>X70-19_1_3_2-70-(2)-10072020.png</center>-->
+
  
−
In the '''Template Properties '''form’s '''Task Links '''tab, the '''Import predecessors''' checkbox is normally '''unchecked''' meaning that the '''Data-driven Task Link import '''feature is turned '''OFF'''.  OnePager Express assumes that the '''Predecessors field''' from the Microsoft Excel '''source plan''' is used for the '''Data-driven Task Link''' information source.   OnePager Express only '''imports predecessor data '''from the Microsoft Excel '''predecessor field'''.  Although OnePager Express does not '''import''' '''Successor '''data from your '''source plan''', '''successor '''information''' '''is the inverse on '''predecessor '''information found in your '''source plan'''.  This approach guaranties that all your '''Data-driven''' '''Task Links''' are based on valid information from your Microsoft Excel '''source plan'''.
+
<center>[[File:P72-24_5_3-72-(1)-11022023.png]]</center>
 +
<center>P72-24_5_3-72-(1)-11022023.png</center>
  
−
==Rules for Importing Data-Driven Task Links – Chart Properties Form Rules==
+
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:
  
−
The requirements for '''importing data-drive Task Links''' '''after''' a chart is '''created''' are discussed in this sub-section. Assume for a moment that the current '''Template Properties '''form is configured in the '''Task Links ''' tab such that the '''Show task links''' checkbox is checked '''ON''', the '''Import predecessors''' checkbox is checked '''OFF''', and the chart is '''created''' and looks like this:
+
<center>[[File:P72-24_5_3-72-(5)-11272023.png]]</center>
 +
<center>P72-24_5_3-72-(5)-11272023.png</center>
  
−
<center>[[File:X70-19_1_3_2-70-(3)-10072020.png]]</center>
+
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.
−
<!--<center>X70-19_1_3_2-70-(3)-10072020.png</center>-->
+
  
−
In this situation, the chart above is '''created without''' the '''import '''of '''Data-driven Task Links''' thus they cannot be '''shown'''.  To '''import '''and '''show''' all '''Data-driven Task Links''', the '''Chart Properties ''' form must be accessed and the '''Import and show links''' checkbox in the '''Data-Driven Task Links '''control group of the '''Chart Properties '''form’s '''Task Links '''tab must be checked '''ON''' as shown here:
+
===Enabling Splitting===
  
−
<center>[[File:X70-19_1_3_2-70-(4)-10072020.png]]</center>
+
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>X70-19_1_3_2-70-(4)-10072020.png</center>-->
+
  
−
When you click the '''Apply''' or '''OK''' button on the '''Chart Properties''' form, OnePager Express goes back to your '''source plan''', '''imports''' the available '''Dependency '''information, and '''shows''' the '''Data-driven Task Links '''that comply with the '''show''' '''rules''' discussed below. The revised chart then looks like this:
+
<center>[[File:P72-24_5_3-72-(2A)-11022023.png]]</center>
 +
<center>P72-24_5_3-72-(2A)-11022023.png</center>
  
−
<center>[[File:X70-19_1_3_2-70-(5)-10072020.png]]</center>
+
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>X70-19_1_3_2-70-(5)-10072020.png</center>-->
+
  
−
At this point '''Data-driven Task Links''' can be '''edited''' by changing the '''show/hide''' status or by  '''editing '''their '''format properties'''.
+
<center>[[File:P72-24_5_3-72-(2AA)-11022023.png]]</center>
 +
<center>P72-24_5_3-72-(2AA)-11022023.png</center>
  
−
For more information on '''editing Task Links''', please see the articles at: [[Editing Task Links with the Chart Properties Form for OnePager Express for Version 7.0 | Editing Task Links with the Chart Properties Form for OnePager Express]] <!--19.3.2-70--> and [[Manual Editing of Task Links for OnePager Express for Version 7.0 | Manual Editing of Task Links for OnePager Express]] <!--19.4.2-70-->
+
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:
  
−
==Rules for Showing Data-Driven Task Links==
+
<center>[[File:P72-24_5_3-72-(2AAA)-11022023.png]]</center>
 +
<center>P72-24_5_3-72-(2AAA)-11022023.png</center>
  
−
===Rules Regarding Imported Tasks and Milestones===
+
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.
  
−
Although OnePager Express '''imports''' all '''Dependency '''information when the conditions stated above are met, '''Data-driven Task Links''' are not always eligible to be '''shown '''in the chart unless the conditions stated below are also met.  For a '''Data-driven Task Link''' to be '''shown '''in the chart, its '''source plan predecessor '''and '''successor''' tasks must be '''Flagged '''for '''import''' by OnePager Pro.  If either the '''source plan predecessor''' or '''successor''' task in the pair is '''not imported''', OnePager Express cannot '''show''' its associated '''Data-driven Task Link''' although the '''Dependency''' information is '''imported'''.
+
===Split Resources in the Chart===
  
−
One or both of the '''source plan Predecessor/Successor''' pair of tasks '''must be''' within the '''Start/Finish Date boundaries''' for the chart for the corresponding '''Data-driven Task Link''' to be '''shown'''.  OnePager Express shows '''Data-driven Task Link connection lines '''to tasks that are outside the '''Start/Finish Date boundaries''' as long as one of the pair is within the '''boundaries'''.
+
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:
  
−
===Rules Regarding Hiding Predecessor or Successor Task/Milestone(s)===
+
<center>[[File:P72-24_5_3-72-(2)-11022023.png]]</center>
 +
<center>P72-24_5_3-72-(2)-11022023.png</center>
  
−
If you '''hide''' a '''predecessor '''or '''successor '''task bar/milestone symbol that was previously '''imported''', the task bar/milestone symbol is '''hidden'''.  Any associated '''Task Links '''('''Data-driven''' or manual) '''are''' '''hidden'''.  And the '''Where Are My Links? '''form (see the subsection following) contains an entry or entries for the associated '''Task Link(s) '''with the '''Show '''column’s checkbox '''unchecked'''.   The '''Where’s My Stuff!?''' form also has an entry or entries for any of the '''hidden '''task bar/milestone symbol(s).
+
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'''.
  
−
For more information on '''hiding''' task bars/milestone symbols and the '''Where’s My Stuff?''' form, please see the articles at:  [[Hiding/Unhiding/Moving/Finding/Changing/Resizing Task/Milestone Shapes and Labels for Version 7.0 | Hiding/Unhiding/Moving/Finding/Changing/Resizing Task/Milestone Shapes and Labels]] <!--9.3.1-70--> and [[Managing Hidden Tasks and Milestones Using "Where's My Stuff?!" for Version 7.0 | Managing Hidden Tasks and Milestones Using "Where's My Stuff?!"]] <!--9.4.1-70-->
+
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'''.
  
−
You are not able to '''check '''the '''Show''' checkbox for such an entry in the '''Where Are My Links?''' form to '''restore''' the '''Data-driven Task Link''' to the '''show status''' as long as its associated task bar/milestone symbol(s) remain '''hidden'''.  A '''tool tip''' is provided when you hover over the '''Show '''column checkbox under these conditions.
+
==Splitting Resources and Task Links==
  
−
To '''restore''' the '''hidden Task Link(s)''' to the '''show''' status you must first '''unhide''' the task bar/milestone symbol(s) by either:
+
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.
−
 
+
−
:1) Using the '''Where’s My Stuff!? '''form to '''unhide''' the '''hidden''' task bar/milestone symbol(s),
+
−
 
+
−
:2) Use the OnePager ribbon’s '''Home''' tab's '''Show/Hide''' dropdown list’s '''Show All Task/Milestones''' command, or
+
−
 
+
−
:3) Use the '''UNDO''' command on the OnePager ribbon if you are able.
+
−
 
+
−
Once the '''hidden''' task bar/milestone symbol(s) are in the '''show''' status, their '''Task Links''' are changed to the '''show''' status as well.
+
−
 
+
−
==Managing Task Links in the Chart==
+
−
 
+
−
After '''Data-driven Task Links''' are '''imported''' and are being '''shown''' in the chart, OnePager Express provides you a tool for managing your '''Task Links''' as described in the following subsections:
+
−
 
+
−
===The OnePager Express Where Are My Links? Form===
+
−
 
+
−
In OnePager Express, the '''Chart Properties '''form '''Task Link '''tab, in the '''Data-Driven Task Links '''control group there is an additional button, the '''Where Are My Links? '''button, as shown here:
+
−
 
+
−
<center>[[File:X70-19_1_2_2-70-70-(6)-10062020.png]]</center>
+
−
<!--<center>X70-19_1_2_2-70-70-(6)-10062020.png</center>-->
+
−
 
+
−
The '''Where Are My Links?''' form can also be accessed from the '''Editing''' control group on the OnePager ribbon’s '''Home''' tab by clicking the '''Show/Hide '''dropdown and selecting the '''Where Are My Links? '''command as shown below:
+
−
 
+
−
<center>[[File:X70-19_1_1_2-70-(4)-10052020.png]]</center>
+
−
<center>X70-19_1_1_2-70-(4)-10052020.png</center>
+
−
 
+
−
Using either the Chart Properties form’s '''Task '''Links tab or the OnePager ribbon '''Home '''tab accesses the '''Where Are My Links?''' form shown here:
+
−
 
+
−
<center>[[File:X70-19_1_3_2-70-(8)-10072020.png]]</center>
+
−
<!--<center>X70-19_1_3_2-70-(8)-10072020.png</center>-->
+
−
 
+
−
The '''Where Are My Links?''' form above lists all the '''Data-driven Task Links shown ('''or '''hidden''') in the current snapshot as well as any manual''' Task Links'''.  The '''Where Are My Links? '''form is '''“snapshot-dependent”''' in that OnePager creates the form’s content based upon the snapshot that is being displayed in the '''Chart Editor '''.  At the top of the form, are controls to '''Filter''' entries showing in the form based upon '''task names''' such that only task bar/milestone symbols that meet the '''task name filtering rule''' appears in the form’s data window. 
+
−
 
+
−
For example, if you want to show only those entries that relate to '''Engineering Team 2''' task bar names, type the task bar name into the window provided and click the '''Filter''' button and the '''Where Are My Links? '''form looks like this:
+
−
 
+
−
<center>[[File:X70-19_1_3_2-70-(9)-10072020.png]]</center>
+
−
<!--<center>X70-19_1_3_2-70-(9)-10072020.png</center>-->
+
−
 
+
−
After clicking the '''Filter '''button the entries shown in the '''Where Are My Links? '''form’s window are only those where the '''Engineering Team 2''' task bar name appears in either a '''Predecessor''' or '''Successor '''task bar/milestone symbol name regardless of whether the '''Task Link '''is '''showing''' (or '''hidden''').  The current '''show/hide status''' is displayed in the '''Show '''column’s checkboxes.  Clicking the '''Clear Filter''' button restores all the entries in the '''Where Are My Links?''' form and clears the contents of the search window.
+
−
 
+
−
There are four (4) columns in the '''Where Are My Links? '''form.
+
−
 
+
−
In the '''Show '''column (1)''' '''you can check or uncheck any entry’s checkbox to control the '''showing''' (or '''hiding'''), respectively, of the associated '''Task Links. '''
+
−
 
+
−
The '''Predecessor''' column (2) and '''Successor '''column (3) provide the '''Task/Milestone Name''' participating respectively in the '''Task Link''' pair.  The numbers in parenthesis following the task name correspond to the '''Task ID''' for Microsoft Excel '''source plans'''. 
+
−
 
+
−
The '''Source''' column (4) tells you which entries in the form are '''Data-driven Task Links (Imported) '''or which are manual '''Task Links''' ('''Manual'''). The four columns in the form can be '''sorted''' by clicking on the '''column’s header'''.
+
−
 
+
−
Sorting on the '''Show '''column means that you are sorting between checked and unchecked entries.  Sorting on the '''Predecessor''' or '''Successor '''columns means that you are sorting alphanumerically on the contents of the entire field.  Because of the relationship between these two columns, sorting on the '''Predecessor''' column, for example, brings along the corresponding '''Successor''' entry and vice versa.  Sorting on the '''Source '''column means that you are sorting between '''Imported''' and '''Manual '''entries.
+
−
 
+
−
The '''Use Show/Hide Defaults''' button at the bottom of the form controls the '''resetting of defaults''' for '''showing ('''or '''hiding''')''' Task Links''' based upon the '''Task Link Filter rules '''you established in the '''Task Link Filter Rules '''form.  This button also applies if you are '''Showing All Task Links''' instead of using '''Task Link Filter rules'''. 
+
−
 
+
−
If after establishing which '''Task Links '''are to be '''shown''' (or '''hidden''') in the '''Task Links Filter Rules '''form and you later make '''edits''' to any '''Task Link '''individually, clicking the '''Use Show/Hide Defaults '''button '''restores''' all '''Task Links '''to the current '''Task Link Filter rules''' or the '''Show all '''selection. 
+
−
 
+
−
The two other buttons at the bottom of the '''Where Are My Links? '''form can be used to override any pre-established '''filtering rules''' and force either a '''Show All''' or '''Hide All''' '''Task Link '''entries in the chart.  These two controls are shortcuts that are applied to all entries in the '''Where Are My Links? '''form.
+
−
 
+
−
===Using the Where Are My Links? Form to Show or Hide Task Link===
+
−
 
+
−
Use the form to quickly '''edit''' the '''show/hide status '''of any '''Task Link '''entry in the form for the '''current snapshot''' by either checking ('''ON''') or unchecking ('''OFF''') the checkbox in the '''Show '''column of the form for the '''Task Link '''entry you want to '''edit'''.
+
−
 
+
−
The '''Where Are My Links? '''form is shown below:
+
−
 
+
−
<center>[[File:X70-19_1_3_2-70-(10)-10072020.png]]</center>
+
−
<!--<center>X70-19_1_3_2-70-(10)-10072020.png</center>-->
+
−
 
+
−
The '''Where Are My Links? '''form is '''“snapshot-dependent”''' in that OnePager provides a list of '''Task Links''' specific to the snapshot that you are currently displaying in the '''Chart Editor'''.  If you don’t use the '''Task Links Filter Rules''' form to conditionally control the '''showing ('''or '''hiding''') of '''Data-driven Task Links''', the '''Where Are My Links?''' form gives you total manual control over the '''showing''' (or '''hiding''')''' '''of all '''Task Links''' in a snapshot at any time.
+
−
 
+
−
For more information  on the controls in the '''Where Are My Links?''' form, please see the article at: [[Using the Where Are My Links? Form for OnePager Express for Version 7.0 | Using the Where Are My Links? Form for OnePager Express]] <!--19.5.2-70-->
+
−
 
+
−
'''Editing''' the '''show/hide status '''of '''Task Link(s) '''in the '''Where Are My Links?''' form as described above can turn the '''edited Task Link(s) '''into '''maverick Task Link(s)'''.  The '''edit''' made to any entry in the '''Where Are My Links?''' form applies to the '''current snapshot'''.
+
  
 
==Related Links==
 
==Related Links==
  
−
[[Hiding/Unhiding/Moving/Finding/Changing/Resizing Task/Milestone Shapes and Labels for Version 7.0 | Hiding/Unhiding/Moving/Finding/Changing/Resizing Task/Milestone Shapes and Labels]] <!--9.3.1-70-->
+
{| class="wikitable"
 +
| [[Templates versus Charts for Version 7.2 | Templates versus Charts]] 4.0.1.3-72
 +
| [[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
 +
|}
  
−
[[Managing Hidden Tasks and Milestones Using "Where's My Stuff?!" for Version 7.0 | Managing Hidden Tasks and Milestones Using "Where's My Stuff?!"]] <!-- 9.4.1-70-->
+
(24.5.9-72)
  
−
[[Editing Task Links with the Chart Properties Form for OnePager Express for Version 7.0 | Editing Task Links with the Chart Properties Form for OnePager Express]] <!--19.3.2-70-->
+
[[Category:Version 7.2]]
−
 
+
[[Category:Editing the Chart]]
−
[[Manual Editing of Task Links for OnePager Express for Version 7.0 | Manual Editing of Task Links for OnePager Express]] <!--19.4.1-70-->
+
[[Category:Task/Milestone Editing]]
−
 
+
[[Category:Column Splitting]]
−
[[Using the Where Are My Links? Form for OnePager Express for Version 7.0 | Using the Where Are My Links? Form for OnePager Express]] <!--19.5.2-70-->
+
[[Category:Charts]]
−
 
+
−
(19.1.3.2-70)
+
−
 
+
−
[[Category:Version 7.0]]
+
−
[[Category:OnePager Express]]
+
 
[[Category:Task Links]]
 
[[Category:Task Links]]
 +
[[Category:Ribbon]]
 
[[Category:Snapshots]]
 
[[Category:Snapshots]]
−
[[Category:Charts]]
+
[[Category:Template Properties Form]]
−
[[Category:Edit the Chart]]
+
[[Category:Chart Properties Form]]
−
[[Category:Snapshot Independent]]
+
[[Category:Asana]]
−
[[Category:Task/Milestone]]
+
[[Category:OnePager Bundle]]
−
[[Category:Template]]
+
−
[[Category:Chart Properties]]
+
−
[[Category:Task Links Tab]]
+
−
[[Category:Where Are My Links?]]
+
−
[[Category:Where’s My Stuff?!]]
+

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)

Retrieved from "https://wiki.onepager.com/wiki/index.php?title=Testing_Article1&oldid=55377"