Difference between revisions of "Testing Article1"

From OnePager Documentation
Jump to: navigation, search
(Split Resources in the Chart)
 
(582 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Overview==
+
==Introduction==
  
The '''creation''', '''formatting''', '''sorting''', and '''editing''' of '''rows''', '''swimlane levels''', and '''text columns''' was covered in the three articles in this series shown below:
+
This article is focused on using the ''' Column Splitting''' feature with OnePager Bundle '''Standalone''' and '''imported''' Asana '''source plans'''.
  
:* [[Collecting, Formatting, and Sorting Task/Milestones into Rows for Version 7.0 | Collecting, Formatting, and Sorting Task/Milestones into Rows]] <!--12.01.1-70-->
+
==About Splitting and Parsing Fields==
  
:* [[Creating, Formatting, and Sorting Swimlanes Levels for Version 7.0 | Creating, Formatting, and Sorting Swimlanes Levels]] <!--12.02.1-70-->
+
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.
  
:* [[Creating and Formatting Text Columns for Version 7.0 | Creating and Formatting Text Columns]] <!--12.03.1-70-->
+
===Split Resource Names Example===
  
While these articles mentioned the topic of '''borders '''for '''rows '''and '''swimlanes''', they do not go into any depth while referring to this article. The purpose here is to cover the set of controls you have at your disposal to '''manage row and swimlane borders''' in the chart to include '''showing and hiding''' them, changing their '''visual properties''', and avoiding certain complications arising from the sharing of '''borders '''between '''adjacent rows and swimlanes'''.
+
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:
  
Unlike other control subjects in OnePager, '''borders''' for '''rows''' and '''swimlanes''' are not all located in one form but are positioned as close as possible to the '''graphic elements''' they support.
+
<center>[[File:P72-24_5_3-72-(1)-11022023.png]]</center>
 +
<center>P72-24_5_3-72-(1)-11022023.png</center>
  
This article describes '''row '''and '''swimlane border''' controls for '''global creation''', '''showing/hiding''', and '''editing '''and the techniques for manually '''editing row '''and '''swimlane borders '''in the chartTopics related to the '''management of row borders''' are addressed first followed by the topics related to the '''management of swimlane borders'''.  Lastly, a brief discussion on '''manual editing row''' and '''swimlane borders''' in the '''Chart Editor''' is provided.
+
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:
  
==Managing Row Borders in the Chart Properties Form==
+
<center>[[File:P72-24_5_3-72-(5)-11272023.png]]</center>
 +
<center>P72-24_5_3-72-(5)-11272023.png</center>
  
'''Global row border '''controls are found in the '''Template Properties '''and '''Chart Properties '''form’s '''Rows/Swimlanes '''tab in the top most '''Rows '''control groupThe controls for '''managing row borders''' in these forms are identical so this article uses the '''Chart Properties '''form for the discussion and examples assuming that the charts used in the examples were created with the '''Template ''' oriented toward Gantt chart layoutsThe controls that apply to Gantt chart layouts apply equally well to '''Timeline '''layout charts containing '''rows''' and '''swimlanes''' either at a '''single swimlane level''' or '''multiple swimlane levels'''.
+
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.
  
===The Row Formatting Form in the Chart Properties Form’s Rows/Swimlanes Tab’s Rows Control Group===
+
===Enabling Splitting===
  
Accessing the '''Chart Properties '''form from the OnePager’s '''Home '''ribbon tool bar tab and navigating to the '''Rows/Swimlanes '''tab and its '''Rows '''control group there is a '''Row Border Formatting…''' button in the middle of the control group.  Clicking the '''Row Border Formatting… '''button accesses the '''Row Formatting '''form 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:P70-12_04_1-(1)-07022020.png]]</center>
+
<center>[[File:P72-24_5_3-72-(2A)-11022023.png]]</center>
<!--<center>P70-12_04_1-(1)-07022020.png</center>-->
+
<center>P72-24_5_3-72-(2A)-11022023.png</center>
  
For most OnePager distributed '''Templates''', the '''default setting for row borders '''are that they are '''hidden'''.  As shown in the illustration above, the '''Show Row Borders''' checkbox in the '''Row Formatting '''form is checked '''OFF '''for this '''default setting'''.  To '''show all row borders''', the '''Show Row Borders '''checkbox must be checked '''ON''' which also '''enables''' the remaining controls in the form 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:P70-12_04_1-(2)-07022020.png]]</center>
+
<center>[[File:P72-24_5_3-72-(2AA)-11022023.png]]</center>
<!--<center>P70-12_04_1-(2)-07022020.png</center>-->
+
<center>P72-24_5_3-72-(2AA)-11022023.png</center>
  
There are three '''enabled '''controls in the above form for setting the '''line color '''of the '''row borders '''in the chart, setting the '''width '''of the '''row border lines''', and specifying the '''dash type''' for the '''row border lines'''.
+
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:
  
Clicking the '''Color:''' dropdown window’s button accesses the OnePager standard '''Color Chooser''' form for selected the desired '''color '''for all '''row borders''' as shown here:
+
<center>[[File:P72-24_5_3-72-(2AAA)-11022023.png]]</center>
 +
<center>P72-24_5_3-72-(2AAA)-11022023.png</center>
  
<center>[[File:P70-12_04_1-(3)-07022020.png]]</center>
+
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.
<!--<center>P70-12_04_1-(3)-07022020.png</center>-->
+
  
The '''Width:''' dial operates the same way other '''width '''dials operate in OnePager where '''valid values''' must be '''positive''' and range between '''1.0 and 20.0'''.
+
===Split Resources in the Chart===
  
Recall that the '''Width: '''setting applies to '''all row borders''' in the chart such that excessively '''wide row border settings''' may not have the desired visual effectSince '''row borders '''are used to separate '''rows''' in the chart, their '''width''' can be used to highlight separation between '''rows''' of interest.
+
Clicking the '''Create new chart''' button completes the process and creates the chart with the '''column splitting''' feature in useThe chart with '''splitting''' looks like this:
  
The '''Dash:''' dropdown provides four options for configuring  all '''row borders '''in the chart including the '''solid line''', '''dash line''', a '''dash-dot''', and a '''dash-dot-dot''' as shown below:
+
<center>[[File:P72-24_5_3-72-(2)-11022023.png]]</center>
 +
<center>P72-24_5_3-72-(2)-11022023.png</center>
  
<center>[[File:P70-12_04_1-(4)-07022020.png]]</center>
+
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'''.
<!--<center>P70-12_04_1-(4)-07022020.png</center>-->
+
  
===Row Border Formatting - Examples===
+
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'''.
  
For some examples, we can look at a series of '''row border edits''' starting from the chart below with no '''row or swimlane borders''' but with the '''rows '''in the '''graph''' is '''zebra striped''':
+
==Splitting Resources and Task Links==
  
<center>[[File:P70-12_04_1-(5)-07022020.png]]</center>
+
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.
<!--<center>P70-12_04_1-(5)-07022020.png</center>-->
+
 
+
If we update the '''Row Border Formatting''' form to '''show row borders '''and show them in green with a '''width '''of '''2.0''' using the '''dash-dot-dot dash type''', the chart looks like this:
+
 
+
<center>[[File:P70-12_04_1-(6)-07062020.png]]</center>
+
<!--<center>P70-12_04_1-(6)-07062020.png</center>-->
+
 
+
The illustration above shows the '''row borders '''as intended: (1) green '''color''', (2) '''width 2.0''', and (3) '''dash-dot-dot dash type'''.  The '''row borders '''extend out of the '''graph area '''to the left and include top and bottom '''row borders '''for all '''showing text columns''' in the chart.  Finally, '''row borders '''do not include the top or bottom '''lines''' that make up the '''Inner Frame''' of the chart.
+
Hiding the two '''text column '''modifies the chart as shown below:
+
 
+
<center>[[File:P70-12_04_1-(7)-07022020.png]]</center>
+
<!--<center>P70-12_04_1-(7)-07022020.png</center>-->
+
 
+
The '''Row Borders Formatting''' form can be used at any time to '''edit all row borders '''in the chart.  '''Row borders '''are '''snapshot-independent''' meaning that the last '''row border '''configuration established for the chart appears in all snapshots.  That is, the '''row borders '''do not change from snapshot to snapshot.
+
 
+
==Managing Swimlane Level Borders in the Chart Properties Form==
+
 
+
Like '''global row border '''controls, '''global swimlane level '''controls are found in the '''Template Properties '''and '''Chart Properties '''form’s '''Rows/Swimlanes '''tab in the middle '''Swimlanes '''control group.  The controls for '''managing swimlane borders''' in these forms are identical so this article uses the '''Chart Properties '''form for the discussion and examples assuming that the charts used in the examples were created with the '''Template ''' oriented toward Gantt chart layouts.  The controls that apply to Gantt chart layouts apply equally well to '''Timeline '''layout charts containing '''rows''' and '''swimlanes''' either at a '''single swimlane level''' or '''multiple swimlane levels'''.
+
 
+
===The Swimlane Formatting – Left#n Form in the Chart Properties Form’s Rows/Swimlanes Tab’s Swimlanes Control Group===
+
 
+
Because there are '''three swimlane levels''' available, '''borders''' for each '''swimlane level''' can be managed separately for each '''swimlane level'''.  Like '''row borders''' in the '''graph area''', the controls for '''managing each swimlane level’s borders '''are found in the '''Swimlane Formatting – Left#n '''form accessed by clicking the '''Swimlane Formatting… '''button in the '''Swimlanes '''control group of the '''Chart Properties '''form’s '''Rows/Swimlanes '''tab.  Accessing the '''Chart Properties '''form from the OnePager’s '''Home '''ribbon tool bar tab and navigating to the '''Rows/Swimlanes '''tab and its '''Swimlanes '''control group there is a '''Swimlane Formatting…''' button.
+
 
+
Clicking the '''Swimlane Formatting… '''button accesses the '''Swimlane Formatting – Left#1 '''form as shown in the example below for the '''Left#1 swimlane level''':
+
 
+
<center>[[File:P70-12_04_1-(8)-07022020.png]]</center>
+
<!--<center>P70-12_04_1-(8)-07022020.png</center>-->
+
 
+
For most OnePager distributed '''Templates''', the '''default setting for all swimlane level borders '''are that they are '''hidden'''.  As shown in the illustration above, the '''Show Borders''' checkbox in the '''Row Formatting '''form is checked '''OFF '''for this '''default setting'''.
+
 
+
To '''show swimlane borders '''for a specific '''swimlane level''', the '''Show Borders '''checkbox in the corresponding '''Swimlane Formatting – Left#n '''form must be checked '''ON''' which also '''enables''' the remaining controls in the form as shown below:
+
 
+
<center>[[File:P70-12_04_1-(9)-07022020.png]]</center>
+
<!--<center>P70-12_04_1-(9)-07022020.png</center>-->
+
 
+
There are three '''enabled '''controls in the above form for setting the '''line color '''of the '''row borders '''in the chart, setting the '''width '''of the '''row border lines''', and specifying the '''dash type''' for the '''row border lines'''.
+
 
+
For more information on these controls, please see the previous sub-section at: [[Row and Swimlane Borders for Version 7.0#The Row Formatting Form in the Chart Properties Form’s Rows/Swimlanes Tab’s Rows Control Group | The Row Formatting Form in the Chart Properties Form’s Rows/Swimlanes Tab’s Rows Control Group]] <!--12.04.1-70-->
+
 
+
===Swimlane Level Border Formatting - Examples===
+
 
+
We can look at a series of illustrations for '''swimlane level border edits''' starting from the chart below with no '''row or swimlane borders''' but with the '''Left#1 swimlane level '''in the '''graph''' is '''zebra striped''':
+
 
+
<center>[[File:P70-12_04_1-(10)-07022020.png]]</center>
+
<!--<center>P70-12_04_1-(10)-07022020.png</center>-->
+
 
+
The above illustration shows that the '''zebra striping '''of the '''Left#1 swimlane level ''' is helpful but to highlight the chart better we can first place '''swimlane level borders''' for the '''Left#1 swimlane level''' in the chart by resetting the appropriate controls in the '''Swimlane Formatting – Left#1 '''form to have '''Left#1 swimlane borders '''that are '''colored''' red, with a '''width''' of '''2.0''', and a '''dash type ''' of '''dashed''' as shown below:
+
 
+
<center>[[File:P70-12_04_1-(11-1)-07072020.png]]</center>
+
<!--<center>P70-12_04_1-(11-1)-07072020.png</center>-->
+
 
+
For the purpose of keeping the series of examples simple, and avoiding the matter of '''shared swimlane level borders''', the next example show the chart  with '''Left#2 zebra striping '''and with only '''swimlane level borders '''for the '''Left#2 swimlane level '''where the '''colored''' green, with a line '''width 2.0''', and a '''dash type '''of '''dash-dot''':
+
 
+
<center>[[File:P70-12_04_1-(12-1)-07072020.png]]</center>
+
<!--<center>P70-12_04_1-(12-1)-07072020.png</center>-->
+
 
+
And finally for the '''Left#3 swimlane level''', the illustration below is configured with '''Left#3 zebra striping''', the '''Left#3 swimlane level borders '''are '''colored '''blue,''' '''with a line '''width''' of '''2.0''', and a '''dash type '''of '''solid''':
+
 
+
<center>[[File:P70-12_04_1-(13)-07022020.png]]</center>
+
<!--<center>P70-12_04_1-(13)-07022020.png</center>-->
+
 
+
The examples and illustrations above show how '''swimlane level borders '''appear when shown in the chart individually and without any '''row borders''' showing.  As mentioned earlier and seen in the above examples, there is a potential for '''overlapping swimlane level borders''' when more than one '''swimlane level '''has its '''Show borders '''checkbox checked '''ON''' and its '''swimlane level borders''' configured with distinct '''colors''', line '''widths''', and '''dash types'''.
+
 
+
==Managing Row and Multiple Swimlane Level Borders in the Chart ==
+
 
+
With multiple '''swimlane levels''' potentially showing in the chart, there is the potential for '''row '''and '''swimlane level borders '''to share the same space in the '''graph''', that is, to '''overlap'''.  Displaying '''row''' and '''multiple swimlane level borders''', therefore, may not result in a '''pleasing visual experience''' for your audience.  Accordingly, we recommend that employing different '''colors''', line '''widths''', and '''dash types''' with '''rows''' and '''multiple swimlane levels''' in the chart be approached with some thought, care, and experimentation to assure you achieve the '''desired visual effects'''.
+
 
+
==Manual Editing Row and Swimlane Borders==
+
 
+
1) The previous sub-sections covered the controls for '''managing row''' and '''swimlane borders''' that are available in the '''Template Properties''' and '''Chart Properties''' forms.
+
 
+
2) From the '''Chart Editor''' you also have access to '''context menus''' that access forms and controls for '''managing row''' and '''swimlane borders'''.
+
 
+
===Manual Editing Row and Text Column Cell Borders===
+
 
+
Right-clicking in a '''text column cell''' accesses the '''text column '''right-click '''context menu''' shown below with its '''Properties…''' command where you can '''manage individual row borders''':
+
 
+
<center>[[File:P70-12_04_1-(14-1)-07062020.png]]</center>
+
<!--<center>P70-12_04_1-(14-1)-07062020.png</center>-->
+
 
+
When you click the '''Properties … '''command in the above right-click '''context menu''', you access the '''Row/Column Properties '''form at the '''Row ''' tab as shown here:
+
 
+
<center>[[File:P70-12_04_1-(15-2)-07072020.png]]</center>
+
<!--<center>P70-12_04_1-(15-2)-07072020.png</center>-->
+
 
+
The '''Row''' tab of the '''Row/Column Properties''' form has the controls '''managing the top and bottom borders''' of the selected '''row''' as well as controls for '''editing''' the '''background color '''of the selected '''row'''.  The '''Cell '''tab contains the controls available for '''formatting''' the selected '''text column cell’s text string''', '''Font properties''', '''Alignment''', '''Cell Background Color''', and '''Text Rotation''' as shown below:
+
 
+
<center>[[File:P70-12_04_1-(16-2)-07072020.png]]</center>
+
<!--<center>P70-12_04_1-(16-2)-07072020.png</center>-->
+
 
+
These two '''Row/Column Properties '''form’s tabs have the same controls available for '''row''' and '''text column cell''' '''editing''' on a selected '''row''' or '''text column cell''' basis as those controls available in the '''Template Properties''' and '''Chart Properties''' form’s '''Rows/Swimlanes '''tab.
+
 
+
For a more information on the '''text column '''right-click '''context menu''' commands available, please see the article at: [[Editing Row Properties for Version 7.0 | Editing Row Properties]] <!--12.22.1-70-->
+
 
+
===Manual Editing Swimlanes and Swimlane Level Cell Borders===
+
 
+
Right-clicking in a '''swimlane level cell''' accesses the '''swimlane level '''right-click '''context menu''' shown below with its '''Properties…''' command where you can '''manage individual swimlane level borders''':
+
 
+
<center>[[File:P70-12_04_1-(17-1)-07062020.png]]</center>
+
<!--<center>P70-12_04_1-(17-1)-07062020.png</center>-->
+
 
+
When you click the '''Properties … '''command in the above right-click '''context menu''' you access the '''Swimlane/Cell Properties '''form at the '''Swimlane '''tab as shown here:
+
 
+
<center>[[File:P70-12_04_1-(18-1)-07062020.png]]</center>
+
<!--<center>P70-12_04_1-(18-1)-07062020.png</center>-->
+
 
+
The '''Swimlane''' tab of the '''Swimlane/Cell Properties''' form has the controls '''managing the top and bottom borders''' of the selected '''swimlane''' as well as controls for '''editing''' the '''background color '''of the selected '''swimlane'''.
+
 
+
The '''Cell '''tab contains the controls available for '''formatting''' the selected '''swimlane level cell’s text string''', '''Font properties''', '''Alignment''', '''Cell Background Color''', and '''Text Rotation''' as shown below:
+
 
+
<center>[[File:P70-12_04_1-(19-1)-07062020.png]]</center>
+
<!--<center>P70-12_04_1-(19-1)-07062020.png</center>-->
+
 
+
These two '''Swimlane/Cell Properties '''form’s tabs have the same controls available for '''swimlane''' and '''swimlane level cell''' '''editing''' on a selected '''swimlane''' or '''swimlane level cell''' basis as those controls available in the '''Template Properties''' and '''Chart Properties''' form’s '''Rows/Swimlanes '''tab.
+
 
+
For a more information on the '''swimlane level cell '''right-click '''context menu''' commands available, please see the article at: [[Editing Swimlane Properties for Version 7.0 | Editing Swimlane Properties]] <!--12.23.1-70-->
+
  
 
==Related Links==
 
==Related Links==
  
[[Basic Workflows for Version 7.0 (Portal) | Basic Workflows (Portal)]] <!--7.0.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
 +
|}
  
[[Manual Editing Task/Milestone Shapes and Text Labels for Version 7.0 (Portal) | Manual Editing Task/Milestone Shapes and Text Labels (Portal)]] <!--9.0.1-70-->
+
(24.5.9-72)
  
[[Creating and Editing Rows and Swimlanes for Version 7.0 (Portal) | Creating and Editing Rows and Swimlanes (Portal)]] <!--12.0.1-70-->
+
[[Category:Version 7.2]]
 
+
[[Category:Editing the Chart]]
[[Collecting, Formatting, and Sorting Task/Milestones into Rows for Version 7.0 | Collecting, Formatting, and Sorting Task/Milestones into Rows]] <!--12.01.1-70-->
+
[[Category:Task/Milestone Editing]]
 
+
[[Category:Column Splitting]]
[[Creating, Formatting, and Sorting Swimlanes Levels for Version 7.0 | Creating, Formatting, and Sorting Swimlanes Levels]] <!--12.02.1-70-->
+
 
+
[[Creating and Formatting Text Columns for Version 7.0 | Creating and Formatting Text Columns]] <!--12.03.1-70-->
+
 
+
[[Editing Text Columns or Swimlane Labels for Version 7.0 | Editing Text Columns or Swimlane Labels]] <!--12.3.1-70-->
+
 
+
[[Editing Row Properties for Version 7.0 | Editing Row Properties]] <!--12.22.1-70-->
+
 
+
[[Editing Swimlane Properties for Version 7.0 | Editing Swimlane Properties]] <!--12.23.1-70-->
+
 
+
[[Zebra Striping for Rows and Swimlanes for OnePager Pro for Version 7.0 | Zebra Striping for Rows and Swimlanes for OnePager Pro]] <!--12.24.1-70-->
+
 
+
[[Zebra Striping for Rows and Swimlanes for OnePager Express for Version 7.0 | Zebra Striping for Rows and Swimlanes for OnePager Express]] <!--12.24.2-70-->
+
 
+
[[Editing with the Chart Properties form for Version 7.0 (Portal) | Editing with the Chart Properties form (Portal)]] <!--21.0.1-70-->
+
 
+
[[Managing Templates for Version 7.0 (Portal) | Managing Templates (Portal)]] <!--24.0.1-70-->
+
 
+
[[Microsoft Project Fields Available to OnePager Pro for Version 7.0 | Microsoft Project Fields Available to OnePager Pro]] <!--29.0.1-70-->
+
 
+
(12.04.1-70)
+
 
+
[[Category:Version 7.0]]
+
 
[[Category:Charts]]
 
[[Category:Charts]]
[[Category:Templates]]
+
[[Category:Task Links]]
[[Category:Chart Properties Form]]
+
 
[[Category:Ribbon]]
 
[[Category:Ribbon]]
[[Category:Editing a Chart]]
 
[[Category:OnePager - Tool Bar]]
 
[[Category:Task/Milestone Editing]]
 
[[Category:Rows and Swimlanes]]
 
[[Category:Multiple Swimlane Levels]]
 
[[Category:Text Columns]]
 
[[Category:Swimlane Labels]]
 
[[Category:Row/Swimlane Borders]]
 
[[Category:Labels]]
 
[[Category:Name Label Collision Avoidance]]
 
 
[[Category:Snapshots]]
 
[[Category:Snapshots]]
[[Category:Snapshot Dependent/Independent]]
+
[[Category:Template Properties Form]]
[[Category:Row Stripes]]
+
[[Category:Chart Properties Form]]
[[Category:Swimlane Stripes]]
+
[[Category:Asana]]
[[Category:OnePager Pro]]
+
[[Category:OnePager Bundle]]
[[Category:OnePager Express]]
+

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)