Difference between revisions of "Testing Article1"

From OnePager Documentation
Jump to: navigation, search
(Related Links)
(Split Resources in the Chart)
 
(12 intermediate revisions by the same user not shown)
Line 1: Line 1:
==Overview==
+
==Introduction==
  
OnePager Pro, OnePager Express, and OnePager Bundle version 7.1 and later are '''upgraded''' with the addition of twenty-six (26) new '''hash fill patterns''' for '''task bars''', '''milestone symbols''', '''baselines''',''' deadlines''', and''' endpoints'''.  Additionally, these '''new hash fill patterns''' are available options when you configure '''Conditional Formatting Rules '''for '''task bars/milestone symbols''' and other uses.
+
This article is focused on using the ''' Column Splitting''' feature with OnePager Bundle '''Standalone''' and '''imported''' Asana '''source plans'''.
  
The purpose of this article is to '''overview''' the '''upgraded gradient '''and '''hash fill pattern '''features and the controls available to use these features in the '''Chart Editor'''.  Additionally, several examples are provided.
+
==About Splitting and Parsing Fields==
  
This article uses the '''Chart Properties''' form for most of its examples.  For brevity, this article does not cover the features in the '''Template Properties '''form related to these '''upgrades''' because the controls in the '''Template Properties '''form are identical to those of the '''Chart Properties '''form.
+
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.
  
Illustrations used in this article are from OnePager Pro using data from Microsoft Project but the features, function, controls, and manual edits apply equally to other OnePager editions that import from data sources like Microsoft Excel, Smartsheet, Oracle Primavera P6, Project for the Web, Asana, and Wrike.
+
===Split Resource Names Example===
  
==Making Global Changes to Gradient and Hash Fill Patterns for Task Bars/Milestones==
+
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:
  
In addition to the '''gradient fill patterns''' currently available for differentiating '''task bars/milestone symbols''', we added a set of twenty-six (26) '''hash fill patterns''' that can be used as described above.
+
<center>[[File:P72-24_5_3-72-(1)-11022023.png]]</center>
 +
<center>P72-24_5_3-72-(1)-11022023.png</center>
  
===Gradient Fill Pattern Controls===
+
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 '''gradient fill patterns''' are shown below as an example at the '''Chart Properties''' form’s '''Task Bars''' tab’s '''Fill dropdown''' in the '''Default Task Bar Styles''' sub-section:
+
<center>[[File:P72-24_5_3-72-(5)-11272023.png]]</center>
 +
<center>P72-24_5_3-72-(5)-11272023.png</center>
  
<center>[[File:P71-0_4-71-(2-1)-03142022.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>P71-0_4-71-(2-1)-03142022.png</center>
+
  
===Hash Fill Pattern Controls===
+
===Enabling Splitting===
  
When you click the '''Hash Patterns''' sub-tab shown above, the dropdown form containing all the available '''hash fill patterns '''appears 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:P71-0_4-71-(2A-1)-03142022.png]]</center>
+
<center>[[File:P72-24_5_3-72-(2A)-11022023.png]]</center>
<center>P71-0_4-71-(2A-1)-03142022.png</center>
+
<center>P72-24_5_3-72-(2A)-11022023.png</center>
  
For a complete list of '''gradient''' and '''hash fill patterns''', please see the article at:  
+
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>
+
<center>[[File:P72-24_5_3-72-(2AA)-11022023.png]]</center>
{| class="wikitable"
+
<center>P72-24_5_3-72-(2AA)-11022023.png</center>
| [[Gallery of Gradient and Hash Fill Patterns for Version 7.2 | Gallery of Gradient and Hash Fill Patterns]] 29.2.1-72
+
|}
+
</center>
+
  
===Examples of Gradient Fill Patterns and Hash Fill Patterns===
+
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:
  
Using the '''Chart Properties '''form’s '''Task Bars''' tab and the '''chart''' shown below, you can change the '''gradient fill pattern '''for all task bars/milestone symbols:
+
<center>[[File:P72-24_5_3-72-(2AAA)-11022023.png]]</center>
 +
<center>P72-24_5_3-72-(2AAA)-11022023.png</center>
  
<center>[[File:P71-0_4_3-71-(1-1)-03152022.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>P71-0_4_3-71-(1-1)-03152022.png</center>
+
  
When you click the '''OK '''button, the '''selected gradient fill pattern''' is applied to all task bars as shown below:
+
===Split Resources in the Chart===
  
<center>[[File:P71-0_4_3-71-(2)-08102021.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>P71-0_4_3-71-(2)-08102021.png</center>
+
  
In a similar way, starting with the original chart, all the task bars can have their '''fill patterns''' changed to a specific '''hash fill pattern''' as shown in the sequence below:
+
<center>[[File:P72-24_5_3-72-(2)-11022023.png]]</center>
 +
<center>P72-24_5_3-72-(2)-11022023.png</center>
  
<center>[[File:P71-0_4_3-71-(3-2)-03152022.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>P71-0_4_3-71-(3-2)-03152022.png</center>
+
  
When you click the '''OK '''button, the '''selected hash fill pattern''' is applied to all task bars as shown below:
+
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'''.
  
<center>[[File:P71-0_4_3-71-(4)-08102021.png]]</center>
+
==Splitting Resources and Task Links==
<center>P71-0_4_3-71-(4)-08102021.png</center>
+
  
==Making Gradient and Hash Fill Patterns Changes to Individual Task Bars/Milestone Symbols==
+
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.
 
+
'''Gradient fill patterns''' and '''hash fill patterns''' can also be applied to '''individually selected''' task bars/milestones symbols using the '''Change Task/Milestone Properties''' form. If you '''select''' a task bar as shown in the illustration below by right-clicking on the task bar and then clicking the '''Format '''command in the '''right-click context menu''', you can access the '''Change Task/Milestone Properties '''form at its '''Format '''tab:
+
 
+
<center>[[File:P71-0_4_3-71-(5)-08102021.png]]</center>
+
<center>P71-0_4_3-71-(5)-08102021.png</center>
+
 
+
Using the dropdown, select the '''gradient fill pattern''' of your choice. When you click the '''OK '''button on the '''Change Task/Milestone Properties''' form, the change is applied to the chart as shown here:
+
 
+
<center>[[File:P71-0_4_3-71-(6)-08102021.png]]</center>
+
<center>P71-0_4_3-71-(6)-08102021.png</center>
+
 
+
You can use this same technique with the '''Change Task/Milestone Properties '''form’s '''Format '''tab to apply different '''hash fill patterns''' to individual task bars/milestone symbols.
+
 
+
==Making Global Changes to Gradient and Hash Fill Patterns for Task Bar/Milestone Symbol Decorations==
+
 
+
In addition to now being able to apply '''gradient fill patterns''' and '''hash fill patterns '''to task bars/milestone symbols, you can also apply these new features to '''baseline''', '''deadline''', and the '''four endpoint decorations'''. 
+
 
+
Complete information on task bar/milestone '''decorations''' can be found in the article at:
+
 
+
<center>
+
{| class="wikitable"
+
|[[Modifying Decorations on Tasks/Milestones for Version 7.2 (Portal) | Modifying Decorations on Tasks/Milestones (Portal)]] 10.0.1-72
+
|}
+
</center>
+
 
+
The controls for these '''task bar/milestone symbol decoration '''features are discussed below with specific examples.
+
 
+
===Baseline Decorations===
+
 
+
To apply these features to '''baseline decorations '''you need to first access the '''Chart Properties '''form at the '''Task Bars''' or '''Milestones '''tabs.  At the '''Task Bars '''or '''Milestones '''tab, navigate to the '''Task Bars Decorations''' control group of the form and check the '''Baseline Properties '''checkbox '''ON'''.  Then click the '''Baselines Properties '''button to access the '''Set baseline properties '''form as shown in the illustration below:
+
 
+
<center>[[File:P71-0_4_3-71-(7-2)-03152022.png]]</center>
+
<center>P71-0_4_3-71-(7-2)-03152022.png</center>
+
 
+
When the '''baseline shape '''and '''hash fill pattern''' changes shown above are applied to the chart, the chart looks like this:
+
 
+
<center>[[File:P71-0_4_3-71-(7A)-08102021.png]]</center>
+
<center>P71-0_4_3-71-(7A)-08102021.png</center>
+
 
+
The '''baseline shape''' was changed to highlight the '''baseline decoration''' in the chart above.
+
 
+
===Deadline Decorations===
+
 
+
To apply these features to '''deadline decorations '''you need to first access the '''Chart Properties '''form at the '''Task Bars''' or '''Milestones '''tabs.  At the '''Task Bars '''or '''Milestones '''tab, navigate to the '''Task Bars Decorations''' control group of the form and check the '''Deadline Properties '''checkbox '''ON'''.  Then click the '''Deadline Properties… '''button to access the '''Set deadline properties '''form as shown in the illustration below:
+
 
+
<center>[[File:P71-0_4_3-71-(8-1)-03152022.png]]</center>
+
<center>P71-0_4_3-71-(8-1)-03152022.png</center>
+
 
+
When the '''gradient fill pattern''' change shown above is applied to the chart, the chart looks like this:
+
 
+
<center>[[File:P71-0_4_3-71-(8A)-08102021.png]]</center>
+
<center>P71-0_4_3-71-(8A)-08102021.png</center>
+
 
+
===Endpoint Decorations===
+
 
+
To apply these features to '''endpoint decorations '''you need to first access the '''Chart Properties '''form at the '''Task Bars''' or '''Milestones '''tabs.  At the '''Task Bars '''or '''Milestones '''tab, navigate to the '''Task Bars Decorations''' control group of the form and check the '''Endpoint Properties '''checkbox '''ON'''.  Then click the '''Endpoint Properties… '''button to access the '''Set endpoint properties '''form as shown in the illustration below:
+
 
+
<center>[[File:P71-0_4_3-71-(9-2)-03152022.png]]</center>
+
<center>P71-0_4_3-71-(9-2)-03152022.png</center>
+
 
+
In the actions taken above, '''Endpoint 1''' is modified to have a '''star shape''' and a specific '''hash fill pattern'''.  To further illustrate '''endpoints''', '''Endpoint 2''' is also '''edited''' to give it a different '''shape''' and '''hash fill pattern'''.  The '''edits '''made to the '''Set endpoint properties''' form for '''Endpoint 2 '''are shown below:
+
 
+
<center>[[File:P71-0_4_3-71-(9A-2)-03152022.png]]</center>
+
<center>P71-0_4_3-71-(9A-2)-03152022.png</center>
+
 
+
When the '''endpoint shapes '''and '''hash fill patterns''' changes shown in the two illustrations above are applied to the chart, the chart looks like this:
+
 
+
<center>[[File:P71-0_4_3-71-(9B)-08102021.png]]</center>
+
<center>P71-0_4_3-71-(9B)-08102021.png</center>
+
 
+
===Using the Background and Foreground Color Controls for Hash Fill Patterns===
+
 
+
====Background Color for Hash Fill Patterns====
+
 
+
When you add a '''hash fill pattern '''to a '''task bar/milestone symbol''', '''deadline''', or '''endpoint''', the '''hash fill pattern '''itself takes on the '''color''' or '''colors''' of the '''task bar/milestone symbol''', '''deadline''', or '''endpoint'''.  The space between the '''hash fill pattern''' and the '''background''' within these '''shapes '''becomes '''white''' as shown below with two task bars containing two different '''hash fill patterns''':
+
 
+
<center>[[File:P71-0_4_3-71-(9C)-08122021.png]]</center>
+
<center>P71-0_4_3-71-(9C)-08122021.png</center>
+
 
+
You have the option to change the '''background color''' of '''task bar/milestone symbols''', '''deadlines''', and '''endpoint symbols''' to make the '''hash fill pattern''' more prominent in the chart.  For example, if you want to '''maverick '''the '''background color''' of the '''ADONIS Subcontractor Selection''' task bar which is shown in the illustration above as '''blue''' with a '''white background''', you can access the '''Change Task/Milestone Properties '''form at the '''Format''' tab for this task bar and navigate to the '''Background '''control as shown here:
+
 
+
<center>[[File:P71-0_4_3-71-(9D)-08122021.png]]</center>
+
<center>P71-0_4_3-71-(9D)-08122021.png</center>
+
 
+
At the point in the illustration above, the '''Background control''' is '''enabled'''.  Clicking on the dropdown button accesses the standard OnePager '''Color Chooser '''form''' '''in which you can select a specific '''color''' for the '''background''' inside the selected task bar while leaving the '''hash fill pattern''' the '''original color''' (i.e., the '''foreground color''').  In the illustrations below, the standard OnePager '''Color Chooser''' form is accessed and the '''color yellow''' is selected for the '''background color'''. 
+
 
+
<center>'''Access the Standard OnePager Color Chooser'''</center>
+
<center>[[File:P71-0_4_3-71-(9E)-08122021.png]]</center>
+
<center>P71-0_4_3-71-(9E)-08122021.png</center>
+
 
+
When you make the '''color selection''' and close the '''Change Task/Milestone Properties '''form, the selected task bar looks like this:
+
 
+
<center>'''Selected Task Bar’s Background Color Changed to Yellow'''</center>
+
<center>[[File:P71-0_4_3-71-(9F)-08122021.png]]</center>
+
<center>P71-0_4_3-71-(9F)-08122021.png</center>
+
 
+
This same procedure can be used to enhance and differentiate '''deadline symbols''' and '''endpoint symbols''' from their respective task bar/milestone symbols when needed to assure that these symbols stand out in the chart.
+
 
+
====Foreground Color for Hash Fill Patterns====
+
 
+
In the context of '''gradients fill patterns''' and '''hash fill patterns''' the '''foreground color''' is set to the '''color''' of the task bar/milestone symbol to which the decorations belong.  You have the option to change the '''foreground color''' of task bars/milestone symbols, '''baselines''', '''deadline''', and '''endpoints''' globally using the '''decoration controls''' in the '''Template Properties '''form and the '''Chart Properties '''form.  You can also '''maverick''' the '''foreground color''' of selected task bars/milestone symbols using the '''Change Task/Milestone Properties''' form at the '''Format '''tab.  There are no controls in the '''Change Task/Milestone Properties '''form for '''mavericking''' the '''foreground color''' for '''baselines''', '''deadlines''', or '''endpoints'''.
+
 
+
===Making Gradient and Hash Fill Patterns Changes to Individual Task Bar/Milestone Symbol Decorations===
+
 
+
'''Decorations '''for task bars and milestone symbols are applied '''globally'''.  Although task bar/milestone symbol '''properties''' can be '''edited''' individually by '''manually selecting''' a task bar or milestone symbol and using the '''Change Task/Milestone Properties '''form’s '''Format '''tab to '''edit''' their '''properties''', it is not possible to '''edit''' the '''shape''', '''gradient fill pattern''', or '''hash fill pattern''' of individual '''baseline''', '''deadline''', or '''endpoint decorations'''. OnePager is configured such that all task bar/milestone symbol '''decorations '''take on '''global properties'''.
+
 
+
==Hash and Gradient Fill Patterns and the Chart Legend==
+
 
+
OnePager updates '''Legend items''' in the '''Legend''' whenever a change is made to the '''hash''' or '''gradient fill pattern''' of task bars/milestone symbols '''globally''' or '''individually'''.  This is illustrated using the starting chart shown below:
+
 
+
<center>[[File:P71-0_4_3-71-(9G)-08122021.png]]</center>
+
<center>P71-0_4_3-71-(9G)-08122021.png</center>
+
 
+
===Allowing Milestone Symbols to Appear in the Legend===
+
 
+
Most OnePager users do not want to have milestone symbols appear in the '''Legend''' especially when the milestone symbols represent the same '''legend category''' as task bars.  If you want milestone symbols to appear in your '''Legend''' as '''legend items''' you need to '''turn OFF''' the '''Do not duplicate task/milestones''' checkbox in the '''Template Properties '''form and/or '''Chart Properties '''form at the '''Legend''' tab as shown below for the '''Chart Properties''' form:
+
 
+
<center>[[File:P71-0_4_3-71-(9K)-08132021.png]]</center>
+
<center>P71-0_4_3-71-(9K)-08132021.png</center>
+
 
+
For more information on the use of the '''Do not duplicate tasks/milestones''', please see the sub-section in the article at: 
+
 
+
<center>
+
{| class="wikitable"
+
| [[Legend Editing Controls for OnePager for Version 7.2#Controlling Duplication of Legend Items | Legend Editing Controls for OnePager - Controlling Duplication of Legend Items]]  15.3.1-72
+
|}
+
</center>
+
 
+
For the purpose of the examples and illustrations that follow, the '''Do not duplicate tasks/milestone''' checkbox is checked '''ON''' so only task bars are shown as '''legend items'''.
+
 
+
===Global Changes to All Task Bars/Milestone Symbols===
+
 
+
Making a '''global''' change to the '''hash fill pattern''' for all task bars/milestone symbols updates the entire '''Legend''' as shown below:
+
 
+
<center>[[File:P71-0_4_3-71-(9H-1)-03152022.png]]</center>
+
<!--<center>P71-0_4_3-71-(9H-1)-03152022.png</center>-->
+
 
+
In the illustration above, all task bars/milestone symbols have their '''hash fill pattern '''changed to the '''Checkerboard (Large) hash fill pattern'''.  When the change is made, the task bars/milestone symbols reflect the change in the '''graph''' and the '''Legend '''is updated to reflect the '''global''' change.
+
 
+
===Changing to a Hash Fill Pattern for an Individual Task Bar/Milestone Symbol===
+
 
+
In a similar way the '''Legend '''is also updated if an individual task bar/milestone symbol is '''mavericked''' to a '''hash fill pattern''' as in the example below starting for the original OnePager chart:
+
 
+
<center>[[File:P71-0_4_3-71-(9I)-08122021.png]]</center>
+
<center>P71-0_4_3-71-(9I)-08122021.png</center>
+
 
+
After accessing the '''Change Task/Milestone Properties''' form for the selected task bar, the '''fill pattern''' is changed to the '''Checkerboard (Large) hash fill pattern'''.  Making this change adds a new '''Legend Item '''to the '''Legend''' showing the '''mavericked''' task bar’s new '''hash fill pattern.'''
+
 
+
===Making Global and Individual Gradient Fill Pattern Changes in the Chart===
+
 
+
OnePager updates the '''Legend''' as described in the two sub-sections above when both '''global''' and '''individual gradient fill pattern''' changes are made to all or individual task bars in the chart as shown below for a '''global '''change:
+
 
+
<center>[[File:P71-0_4_3-71-(9J-1)-03152022.png]]</center>
+
<center>P71-0_4_3-71-(9J-1)-03152022.png</center>
+
 
+
As with the example above for '''global hash fill pattern''' changes, changing the '''gradient fill pattern '''updates all items in the '''Legend'''.  Changes made to individual task bar '''gradient fill patterns''' are also reflected in the '''Legend '''with the addition of a new '''Legend item'''.
+
 
+
For more information on '''Legends''', please see the articles at:
+
 
+
<center>
+
{| class="wikitable"
+
| [[The Chart Legend for Version 7.2 (Portal) | The Chart Legend (Portal)]] 15.0.1-72
+
|}
+
</center>
+
 
+
==Using Gradient and Hash Fill Patterns in Conditional Formatting Rules – An Example==
+
 
+
'''Conditional Formatting Rules''' allow you to dynamically change the '''shape''', '''color''', '''fill pattern''', '''background color''', and other properties of task bars/milestone symbols''' '''based upon a '''rule''' or '''set of rules''' driven by data OnePager '''imports''' from your '''source plan'''.  In OnePager the enhancement for '''gradients '''and '''hash fill patterns '''is extended to '''conditional formatting rules'''.
+
 
+
Before proceeding further, if you need to refresh your knowledge of '''Conditional Formatting Rules''', please see the articles at:
+
 
+
<center>
+
{| class="wikitable"
+
| [[Conditional Formatting for Version 7.2 (Portal) | Conditional Formatting (Portal)]] 11.0.1-72
+
|}
+
</center>
+
 
+
===Example – Starting Chart Configuration===
+
 
+
To illustrate the use of the new '''gradient '''and '''hash fill patterns''', suppose you are starting off with the chart shown below that consists of a project plan using five (5) different resources where OnePager has created the chart using different colors to represent different '''resources'''.  When this is done, the '''Legend''' reflects the '''resources''' and the '''colors '''OnePager assigned.  The chart looks like this:
+
 
+
<center>[[File:P71-0_4_3-71-(10)-08112021.png]]</center>
+
<center>P71-0_4_3-71-(10)-08112021.png</center>
+
 
+
===Example – Adding Conditional Formatting Rules to Highlight an Issue===
+
 
+
Now suppose there is an issue with '''Team 1''' and '''Team 2''' and you want the chart you plan to use for this '''schedule conversation''' to have the tasks that are the responsibility of '''Team 1''' and '''Team 2''' to stand out clearly.  This can be done by adding '''conditional formatting rules''' that apply different '''hash fill patterns''' to the task bars involved. Using the '''Conditional Formatting Rules''' form shown below, you can configure '''rules''' for '''Team 1''' and '''Team 2''':
+
 
+
<center>'''Creating of Conditional Formatting Rule for Team 1'''</center>
+
<center>[[File:P71-0_4_3-71-(11)-08112021.png]]</center>
+
<center>P71-0_4_3-71-(11)-08112021.png</center>
+
 
+
<center>'''Creating of Conditional Formatting Rule for Team 2'''</center>
+
<center>[[File:P71-0_4_3-71-(12)-08112021.png]]</center>
+
<center>P71-0_4_3-71-(12)-08112021.png</center>
+
 
+
===Example – Chart with Highlighted Task Bars Using Hash Fill Patterns===
+
 
+
Applying these two '''Conditional Formatting Rules '''to the chart, the chart looks like this:
+
 
+
<center>[[File:P71-0_4_3-71-(13)-08112021.png]]</center>
+
<center>P71-0_4_3-71-(13)-08112021.png</center>
+
 
+
'''Conditional Formatting Rules''' can be formulated before the chart is created by adding the '''rules '''to the '''Conditional Formatting Rules''' form in the current '''Template Properties '''form.  The '''Legend''' is updated to reflect the '''hash fill pattern''' changes in the chart.
+
  
 
==Related Links==
 
==Related Links==
  
 
{| class="wikitable"
 
{| class="wikitable"
| [https://www.onepager.com/support/whats-new/hash-fill-patterns.html Hash Fill Patterns (All Editions)]
+
| [[Templates versus Charts for Version 7.2 | Templates versus Charts]] 4.0.1.3-72
| [[Changing Individual Task/Milestone Properties (Color, Shape, Labels, etc.) for Version 7.2 | Changing Individual Task/Milestone Properties (Color, Shapes, Labels, etc.)]] 9.2.1-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
 
|-
 
|-
| [[Modifying Decorations on Tasks/Milestones for Version 7.2 (Portal) | Modifying Decorations on Tasks/Milestones (Portal)]] 10.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
| [[Conditional Formatting for Version 7.2 (Portal) | Conditional Formatting (Portal)]] 11.0.1-72
+
| [[Template Only Features for OnePager Pro for Version 7.2 | Template Only Features for OnePager Pro]] 24.1.1-72
 
|-
 
|-
| [[The Chart Legend for Version 7.2 (Portal) | The Chart Legend (Portal)]] 15.0.1-72
+
| [[Template Only Features for OnePager Express for Version 7.2 | Template Only Features for OnePager Express]] 24.2.1-72
| [[Gallery of Gradient and Hash Fill Patterns for Version 7.2 | Gallery of Gradient and Hash Fill Patterns]] 29.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
 
|-
 
|-
| [[Gallery of Dynamic Shapes and Emoji Symbols for Version 7.2 | Gallery of Dynamic Shapes and Emoji Symbols]] 29.3.1-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
 +
|}
  
(0.4.3-71)
+
(24.5.9-72)
  
 
[[Category:Version 7.2]]
 
[[Category:Version 7.2]]
[[Category:Gradient Fill Patterns]]
+
[[Category:Editing the Chart]]
[[Category:Hash Fill Patterns]]
+
[[Category:Task/Milestone Editing]]
 +
[[Category:Column Splitting]]
 
[[Category:Charts]]
 
[[Category:Charts]]
 +
[[Category:Task Links]]
 +
[[Category:Ribbon]]
 +
[[Category:Snapshots]]
 
[[Category:Template Properties Form]]
 
[[Category:Template Properties Form]]
 
[[Category:Chart Properties Form]]
 
[[Category:Chart Properties Form]]
[[Category:Conditional Formatting]]
+
[[Category:Asana]]
[[Category:Editing a Chart]]
+
[[Category:Task/Milestone Editing]]
+
[[Category:OnePager Pro]]
+
[[Category:OnePager Express]]
+
 
[[Category:OnePager Bundle]]
 
[[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)