Difference between revisions of "Testing Article1"

From OnePager Documentation
Jump to: navigation, search
(→‎Split Resources in the Chart)
 
(481 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
==Overview==
+
==Introduction==
  
−
The '''Custom Date Format '''is a feature in OnePager Express that provides the capability to '''create''' your own '''date formats''' for use in the '''Time Axis''', '''Floating Time Axis''', and other places where OnePager supports various '''date formats'''. As an example, the '''Top Level''' '''Time Axis''' shown below has a user '''created''' '''Custom Date Format''' where the Year is augmented with “Calendar Year” as an added text:
+
This article is focused on using the ''' Column Splitting''' feature with OnePager Bundle '''Standalone''' and '''imported''' Asana '''source plans'''.
  
−
<center>[[File:X70-22_5_2-70-(11)-11242020.png]]</center>
+
==About Splitting and Parsing Fields==
−
<!--<center>X70-22_5_2-70-(11)-11242020.png</center>-->
+
  
−
Access to the feature is provided through the '''Chart Properties''' form '''Time Axis '''tab’s '''Calendar '''sub-tab in the '''Formatting & Layout''' control 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_2-70-(1)-11242020.png]]</center>
+
===Split Resource Names Example===
−
<!--<center>X70-22_5_2-70-(1)-11242020.png</center>-->
+
  
−
Clicking the '''Manage Custom Date Formats''' button accesses the '''Add Custom-Date Format''' form at the beginning of the '''creation''' or '''editing''' process as shown above.  '''Custom Date Formats''' are also supported in the OnePager '''Template Properties '''form at the '''Time Axis '''tab’s '''Calendar '''sub-tab shown here:
+
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_2-70-(2)-11242020.png]]</center>
+
<center>[[File:P72-24_5_3-72-(1)-11022023.png]]</center>
−
<!--<center>X70-22_5_2-70-(2)-11242020.png</center>-->
+
<center>P72-24_5_3-72-(1)-11022023.png</center>
  
−
The intent of this article is to provide the information essential for you to '''create''', '''edit''', and '''manage''' your own '''date formats'''.
+
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 Custom Date Format Feature==
+
<center>[[File:P72-24_5_3-72-(5)-11272023.png]]</center>
 +
<center>P72-24_5_3-72-(5)-11272023.png</center>
  
−
The '''Custom Date Format '''feature is accessible from the '''Chart Properties '''and '''Template '''forms.  Creating a '''Custom Date Format''' in the '''Template Properties '''form allows you to '''create''' '''Custom Date Format '''and use it in any chart created using that specific '''Template'''.  Creating a '''Custom Date Format '''in the '''Chart Properties '''form allows you to '''create''' '''Custom Date Format''' and use it in charts created with that specific '''Chart Properties '''form and in an follow on snapshots that might be created subsequently.  '''Chart Properties''' forms containing '''Custom Date Formats '''can be '''saved''' as '''Template Properties '''forms for future use and to standardize '''Date Formats '''throughout an organization.
+
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.
  
−
===Using the Chart Properties Form to Create and Edit Custom Date Formats===
+
===Enabling Splitting===
  
−
You can access controls for the new feature for '''creating''' and '''editing''' '''Custom Date Formats '''by accessing the '''Chart Properties '''form '''Time Axis '''tab’s '''Calendar '''sub-tab in the '''Formatting & Layout '''control group by clicking the '''Manage Custom Date Formats''' button as shown here:
+
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_4_2-70-(3)-11232020.png]]</center>
+
<center>[[File:P72-24_5_3-72-(2A)-11022023.png]]</center>
−
<!--<center>X70-22_4_2-70-(3)-11232020.png</center>-->
+
<center>P72-24_5_3-72-(2A)-11022023.png</center>
  
−
When this button is clicked, the '''Add Custom-Date Format''' form is accessed 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_4_2-70-(4)-11232020.png]]</center>
+
<center>[[File:P72-24_5_3-72-(2AA)-11022023.png]]</center>
−
<!--<center>X70-22_4_2-70-(4)-11232020.png</center>-->
+
<center>P72-24_5_3-72-(2AA)-11022023.png</center>
  
−
This form allows you to '''add Custom Date Formats''' by typing in the desired '''format''' in the '''Date Format''' window shown in the form above.
+
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:
  
−
After typing in the new '''Date Format''' into the window provided and clicking the '''Add Format''' button as shown here the software provides an example of the '''Custom Date Format''' in the '''Sample''' window after you click the '''See the format''' button:
+
<center>[[File:P72-24_5_3-72-(2AAA)-11022023.png]]</center>
 +
<center>P72-24_5_3-72-(2AAA)-11022023.png</center>
  
−
<center>[[File:X70-22_5_2-70-(3)-11242020.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>X70-22_5_2-70-(3)-11242020.png</center>-->
+
−
In the form above, there is a link to the OnePager website where all the '''syntax information''' needed to '''create''' your own '''Custom Date Formats''' can be found: [[https://www.onepager.com/support/faq.php?id=123 Format Help]]
+
  
−
When you click the '''Add Format '''button, OnePager accesses the '''Manage Custom Date Formats '''form that includes your new '''Custom Date Format '''in the '''Date Format List '''as shown here:
+
===Split Resources in the Chart===
  
−
<center>[[File:X70-22_5_2-70-(4)-11242020.png]]</center>
+
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:
−
<!--<center>X70-22_5_2-70-(4)-11242020.png</center>-->
+
  
−
The form above is multi-purpose in that it provides a '''Sample''' of the selected '''Custom Date Format''' in the '''Date Format''' window, provides a list of '''Custom Date Formats '''that can be selected for further '''editing''' or '''deleting''', and tells you where the applicable '''time unit''' the '''Custom Date Format '''is going to be applied in the '''Applies to time unit(s): '''window.   Additionally, there is another convenient link to the OnePager website page providing instructions on the '''syntax instructions '''for '''Custom Date Formats''': [[https://www.onepager.com/support/faq.php?id=123 Format Help]]
+
<center>[[File:P72-24_5_3-72-(2)-11022023.png]]</center>
 +
<center>P72-24_5_3-72-(2)-11022023.png</center>
  
−
From the above form you can choose to '''create''' another '''Custom Date Format '''by clicking the '''Add Format '''button or '''delete''' the selected '''Custom Date Format''' in the list by clicking the '''Delete Format '''button.  When you are finished, click the '''OK '''button to return to the '''Chart Properties''' form '''Time Axis '''tab’s '''Calendar '''sub-tab.  '''Creating''' your own '''Custom Date Formats''' can be useful when you want the '''text''' displayed in various '''Time Axis '''and '''Floating Time Axis Levels''' for specific meaning beyond what OnePager provides.
+
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 the '''Chart Properties '''form, please see the article at:  [[Time Axis Tab for Version 7.0 (OnePager Express) | Time Axis Tab for OnePager Express]] <!--21.17.2-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'''.
  
−
===Using the Template Properties Form to Create and Edit Custom Date Formats===
+
==Splitting Resources and Task Links==
  
−
The '''Template '''form '''Time Axis '''tab’s '''Calendar '''sub-tab is identical to the corresponding sub-tab in the '''Chart Properties '''form.  The processes for '''creating''', '''editing''', and '''managing''' '''Custom Date Formats''' in the '''Template '''form are identical to the processes used in the '''Chart Properties '''form.  '''Custom Date Formats created''' in the '''Chart Properties''' form can be made into '''Template '''forms by '''saving''' the '''Chart Properties''' form as a '''Template '''form. 
+
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.
−
 
+
−
For more information on '''Making a Template Properties Form from a Chart''', 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-->
+
−
 
+
−
'''Custom Date Formats created''' in a '''Template Properties '''form can be '''edited''' in the '''Template Properties '''form, '''saved''', and used in the creation of future charts.  '''Custom Date Formats created''' in a '''Chart Properties''' form can also be '''edited''' in the '''Chart Properties '''form and '''saved''' for future use in subsequent snapshots.  However, '''edits''' made in the '''Chart Properties '''form to '''Custom Date Formats''' do not change the '''Custom Date Formats '''residing in the basic '''Template '''form used to create the initial chart.
+
−
 
+
−
For more information on the '''Template Properties '''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-->
+
−
 
+
−
===Using the Label Format Dropdown to Create Custom Date Formats===
+
−
 
+
−
'''Custom Date Formats''' can also be '''created''' using the '''Label format '''dropdown found in each of the three (3) '''Chart Properties '''form '''Time Axis '''tab '''Level '''sub-tabs ('''Top Level''', '''Middle Level''', or '''Bottom Level''') shown below:
+
−
 
+
−
<center>[[File:X70-22_1_6-70-(5)-11132020.png]]</center>
+
−
<!--<center>X70-22_1_6-70-(5)-11132020.png</center>-->
+
−
 
+
−
Clicking the '''Add Custom Format…''' selection in the dropdown accesses the '''Add Custom-Date Format '''form referenced above.  With the '''Add Custom-Date Format '''form accessed you can '''create''' a new '''Custom Date Format''' that becomes immediately available when the '''Add Format '''button on the '''Add Custom-Date Format '''form is clicked.  After the '''Custom Date Format '''is entered into the '''Add Custom-Date Format '''form it is immediately available in all '''Label format '''dropdown menus.
+
−
 
+
−
For more information on '''Labeling Time Axis Levels''', please see the article at:  [[Labeling Time Axis Levels for OnePager Express for Version 7.0 | Labeling Time Axis Levels for OnePager Express]] <!--22.1.6-70-->
+
−
 
+
−
==Creating and Managing Custom Date Formats==
+
−
 
+
−
In previous versions, OnePager '''date formats''' were the only formats available.  While the '''date formats''' provided mirror those provided for similar features in other applications, you were limited to a finite set.  OnePager provides the capability to '''create''' your own '''Custom Date Formats''' from the '''Year''' down to the '''Second''' with some '''miscellaneous '''options also provided.  You can '''create''' and '''manage''' your own '''Custom Date Formats''' by first clicking the '''Manage Custom Date Formats ''' button on the '''Template Properties''' or '''Chart Properties '''form’s '''Time Axis '''tab at the '''Calendar''' sub-tab as shown here:
+
−
 
+
−
<center>[[File:X70-22_4_2-70-(3)-11232020.png]]</center>
+
−
<!--<center>X70-22_4_2-70-(3)-11232020.png</center>-->
+
−
 
+
−
Clicking the button shown above accesses the '''Add Custom-Date Format''' form where you can construct your '''Custom Date Format''' by typing it in the window indicated below.
+
−
 
+
−
<center>[[File:X70-22_5_2-70-(5)-11242020.png]]</center>
+
−
<!--<center>X70-22_5_2-70-(5)-11242020.png</center>-->
+
−
 
+
−
The above form displays a sample of your '''Custom Date Format''' after you’ve '''created''' it and clicked the '''See the format''' button shown above.
+
−
 
+
−
A '''Hyperlink''' is provided in the form as '''Format Help''' [[https://www.onepager.com/support/faq.php?id=123 Format Help]] that takes you to the OnePager website page where all the syntax information and examples for '''creating''' a '''Custom Date Format''' are provided.
+
−
 
+
−
When you’ve finished '''creating''' your '''Custom Date Format''', click the '''Add Format '''button and your '''Custom Date Format''' is displayed in the '''Manage Custom Date Formats''' form which is accessed and shown below.  If more than one '''Custom Date Format''' is '''created''', this form displays them all and makes them available for future '''editing'''.
+
−
 
+
−
<center>[[File:X70-22_5_2-70-(6)-11242020.png]]</center>
+
−
<!--<center>X70-22_5_2-70-(6)-11242020.png</center>-->
+
−
 
+
−
An example helps illustrate the process.  Suppose you want to '''create''' a '''Custom Date Format''' that displays the year followed by the text '''“Calendar Year”'''.
+
−
 
+
−
===Custom Date Format - An Example===
+
−
 
+
−
Access the '''Add Custom-Date Format''' form as described above and type your desired '''Custom Date Format''' into the '''Date Format '''window as shown below:
+
−
 
+
−
<center>[[File:X70-22_5_2-70-(6A)-11242020.png]]</center>
+
−
<!--<center>X70-22_5_2-70-(6A)-11242020.png</center>-->
+
−
 
+
−
The '''Custom Date Format '''consists of a '''“code”''' for the type of '''date format''' and can be followed by '''text''' enclosed in either single or double quotes.  The example above shows a four digit code for years expressed as '''yyyy'''. 
+
−
This is followed by the double quote enclosed text – '''Calendar Year'''.  Text and date codes can be interchanged.  '''Codes''' for the various '''date formats''' supported are fairly intuitive.  For instance the code for '''day '''is a '''d'''.
+
−
 
+
−
When you finish adding your '''Custom Date Format''', click the '''Add Format '''button on the '''Add Custom-Date Format '''form which accesses the '''Manage Custom Date Format '''form with your '''Custom Date Format''' added as shown here:
+
−
 
+
−
<center>[[File:X70-22_5_2-70-(7)-11242020.png]]</center>
+
−
<!--<center>X70-22_5_2-70-(7)-11242020.png</center>-->
+
−
 
+
−
The process is completed at this point by clicking the '''OK '''button on the '''Manage Custom Date Formats''' form or you can go back to the '''Add Custom-Date Format''' form by clicking the '''Add Format '''button to '''create''' another '''Custom Date Format'''.  You have the option in the '''Manage Custom Date Formats''' form to '''edit''' any '''Custom Date Format''' listed by selecting it and '''editing''' it in the '''Date Format''' window.  You can also '''delete''' any selected '''Custom Date Format''' from the list by selecting it and click the '''Delete Format''' button.  When you’ve finished and either clicked the '''Apply''' or '''OK '''button on the '''Chart Properties '''form, OnePager adds your '''Custom Date Format''', in this case a '''Year''', to the list of '''Date formats''' already predefined by OnePager. 
+
−
 
+
−
The added '''Custom Date Format''' can be seen in the dropdown list example shown below:
+
−
 
+
−
<center>[[File:X70-22_5_2-70-(8)-11242020.png]]</center>
+
−
<!--<center>X70-22_5_2-70-(8)-11242020.png</center>-->
+
−
 
+
−
When you click '''Apply''' or '''OK '''in the '''Chart Properties '''form, the '''Top Level Time Axis''' looks like this:
+
−
 
+
−
<center>[[File:X70-22_5_2-70-(9)-11242020.png]]</center>
+
−
<!--<center>X70-22_5_2-70-(9)-11242020.png</center>-->
+
−
 
+
−
You can also access the '''Add Custom-Date Format '''from the first entry in the '''Label format '''dropdown as shown below:
+
−
 
+
−
<center>[[File:X70-22_5_2-70-(10)-11242020.png]]</center>
+
−
<!--<center>X70-22_5_2-70-(10)-11242020.png</center>-->
+
−
 
+
−
'''Custom Date Formats''' added in the '''Chart Properties''' form are retained as long as the charts associated with the '''Chart Properties '''are available.  The '''Custom Date Format''' can be used in any snapshot associated with the chart and the '''Chart Properties''' form.  The '''Custom Date Format''' available in such a chart can be '''edited''' through the '''Chart Properties''', as shown earlier, and used, as modified, in all snapshots.  '''Custom Date Formats''' added to a '''Template''' form are available for all charts created with that '''Template''' form.   '''Custom Date Formats''' included in a '''Chart Properties''' form are retained in a '''Template Properties '''form '''created''' from that '''Chart Properties''' form as explained above.
+
−
 
+
−
==Custom Date Format Syntax==
+
−
 
+
−
As shown in the examples above the '''syntax''' for a '''Custom Date Format''' is a combination of '''English letters '''as codes with options for you to add '''text''' enclosed in either '''single or double quotes'''.  There are also some '''special characters '''such as '''single and double colons''', '''single and double forward slashes''', '''hyphens''', and '''commas''' used as separators.  The '''timespans '''available range from '''seconds''' on up to '''years '''with intermediate periods such as '''days''', '''weeks''', '''months''', and '''quarters'''. 
+
−
 
+
−
Please use this link for a full list of all available '''codes''' and '''special characters''' available for defining '''Custom Date Formats''':  [[https://www.onepager.com/support/faq.php?id=123 Format Help]]
+
  
 
==Related Links==
 
==Related Links==
  
−
[[Labeling Time Axis Levels for OnePager Express for Version 7.0 | Labeling Time Axis Levels for OnePager Express]] <!--22.1.6-70-->
+
{| class="wikitable"
−
 
+
| [[Templates versus Charts for Version 7.2 | Templates versus Charts]] 4.0.1.3-72
−
[[Editing Time Axes with the Chart Properties Form for OnePager Express for Version 7.0 | Editing Time Axes with the Chart Properties Form for OnePager Express]] <!--22.4.2-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
−
 
+
|-
−
[[Template Only Features for Version 7.0 (OnePager Express) | Template Only Features-OnePager Express]] <!--24.2.1-70-->
+
| [[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
−
[[Managing the Current Template for Version 7.0 | Managing the Current Template]] <!--24.6.1-70-->
+
|-
−
 
+
| [[Template Only Features for OnePager Express for Version 7.2 | Template Only Features for OnePager Express]] 24.2.1-72
−
[[Time Axis Tab for Version 7.0 (OnePager Express) | Time Axis Tab for OnePager Express]] <!--21.17.2-70-->
+
| [[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
−
 
+
|-
−
'''Help Page for Adding Custom Date Formats:''' [[https://www.onepager.com/support/faq.php?id=123 Format Help]]
+
| [[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.2-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 AxisTab]]
+
[[Category:Ribbon]]
−
[[Category:Calendar Sub-Tab]]
+
−
[[Category:Floating Time Axis]]
+
−
[[Category:Non-Linear Time Axis]]
+
−
[[Category:Custom Date Formats]]
+
 
[[Category:Snapshots]]
 
[[Category:Snapshots]]
−
[[Category:Template]]
+
[[Category:Template Properties Form]]
−
[[Category:Chart Properties]]
+
[[Category:Chart Properties Form]]
 +
[[Category:Asana]]
 +
[[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)

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