<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Quick Tip: You can add a column to a project view to see the total number of issues in each project. in Workfront Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/quick-tip-you-can-add-a-column-to-a-project-view-to-see-the/m-p/474846#M7675</link>
    <description>&lt;P&gt;Hi Cathy,&lt;/P&gt;&lt;P&gt;I tried to ask people smarter than me for help and they had a couple of questions/thoughts. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;You can “group” by year or month, but that won’t give you an average. It will give you exactly all the issues in that grouping based on a date. For example, you can group on the Entry Date field by month and see groupings of all the issues with Entry Dates in the same month. But you're not going to see an average of anything.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Does that help? If not it would be nice if you could explain what you're trying to do in more detail. An example of a report you would like to see would be helpful so we can give some suggestions.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Thank you!&lt;/P&gt;&lt;P&gt;Kyna&lt;/P&gt;</description>
    <pubDate>Fri, 07 Jan 2022 21:01:18 GMT</pubDate>
    <dc:creator>kynabaker16</dc:creator>
    <dc:date>2022-01-07T21:01:18Z</dc:date>
    <item>
      <title>Quick Tip: You can add a column to a project view to see the total number of issues in each project.</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/quick-tip-you-can-add-a-column-to-a-project-view-to-see-the/m-p/474837#M7666</link>
      <description>&lt;P&gt;To see the total number of issues in each project, add the following text mode code to a blank column in your view:&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;valuefield= totalOpTaskCount&lt;/P&gt;&lt;P&gt;linkedname=direct&lt;/P&gt;&lt;P&gt;valueformat=int&lt;/P&gt;&lt;P&gt;displayname=Total Issues&lt;/P&gt;&lt;P&gt;textmode=true&lt;/P&gt;&lt;P&gt;querysort= totalOpTaskCount&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&lt;I&gt;"Like" this post if you find it helpful!&lt;img class="lia-deferred-image lia-image-emoji" src="https://experienceleaguecommunities.adobe.com/html/@43BD9D96A2457BE379CCDAB3B137C957/emoticons/1f44d.png" alt=":thumbs_up:" title=":thumbs_up:" /&gt;&lt;/I&gt;&lt;/P&gt;&lt;P&gt;&lt;I&gt;To find all previous Quick Tips, go &lt;/I&gt;&lt;A href="https://one.workfront.com/s/topic/0TO4X000000bqnOWAQ/quick-tip?tabset-21363=3" alt="https://one.workfront.com/s/topic/0TO4X000000bqnOWAQ/quick-tip?tabset-21363=3" target="_blank"&gt;&lt;I&gt;here and view the Discussions tab.&lt;/I&gt;&lt;/A&gt;&lt;/P&gt;</description>
      <pubDate>Tue, 21 Sep 2021 15:58:21 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/quick-tip-you-can-add-a-column-to-a-project-view-to-see-the/m-p/474837#M7666</guid>
      <dc:creator>kynabaker16</dc:creator>
      <dc:date>2021-09-21T15:58:21Z</dc:date>
    </item>
    <item>
      <title>Re: Quick Tip: You can add a column to a project view to see the total number of issues in each project.</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/quick-tip-you-can-add-a-column-to-a-project-view-to-see-the/m-p/474838#M7667</link>
      <description>&lt;P&gt;Hi @Kyna Baker - inactive‚ &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;I tested the above text code in project ad task view, but not visible. Could you please help by rechecking this?&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Mvh&lt;/P&gt;&lt;P&gt;Kundan.&lt;/P&gt;</description>
      <pubDate>Wed, 22 Sep 2021 12:06:27 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/quick-tip-you-can-add-a-column-to-a-project-view-to-see-the/m-p/474838#M7667</guid>
      <dc:creator>Kundanism</dc:creator>
      <dc:date>2021-09-22T12:06:27Z</dc:date>
    </item>
    <item>
      <title>Re: Quick Tip: You can add a column to a project view to see the total number of issues in each project.</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/quick-tip-you-can-add-a-column-to-a-project-view-to-see-the/m-p/474839#M7668</link>
      <description>&lt;P&gt;I use this field on my own Project Reports and can confirm it works as a project view column. You can try adding one more line to it but it shouldn't make a difference&lt;/P&gt;&lt;P&gt;&lt;I&gt;namekey=totalOpTaskCount&lt;/I&gt;&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt; &lt;/P&gt;</description>
      <pubDate>Wed, 22 Sep 2021 12:20:03 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/quick-tip-you-can-add-a-column-to-a-project-view-to-see-the/m-p/474839#M7668</guid>
      <dc:creator>MoniqueEvans</dc:creator>
      <dc:date>2021-09-22T12:20:03Z</dc:date>
    </item>
    <item>
      <title>Re: Quick Tip: You can add a column to a project view to see the total number of issues in each project.</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/quick-tip-you-can-add-a-column-to-a-project-view-to-see-the/m-p/474840#M7669</link>
      <description>&lt;P&gt;Thanks @Monique Evans‚ and @Kyna Baker - inactive‚ &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;It works, can we add a condition such as to highlight with colour if no. of issues are more than 1.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Also, condition such as only active issues for example.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Mvh&lt;/P&gt;&lt;P&gt;Kundan.&lt;/P&gt;</description>
      <pubDate>Wed, 22 Sep 2021 14:14:35 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/quick-tip-you-can-add-a-column-to-a-project-view-to-see-the/m-p/474840#M7669</guid>
      <dc:creator>Kundanism</dc:creator>
      <dc:date>2021-09-22T14:14:35Z</dc:date>
    </item>
    <item>
      <title>Re: Quick Tip: You can add a column to a project view to see the total number of issues in each project.</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/quick-tip-you-can-add-a-column-to-a-project-view-to-see-the/m-p/474841#M7670</link>
      <description>&lt;P&gt;I'm glad you got it to work Kundan. This will only work in a project view, not a task view, so I'm glad you tested it again. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Kyna&lt;/P&gt;</description>
      <pubDate>Wed, 22 Sep 2021 14:34:30 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/quick-tip-you-can-add-a-column-to-a-project-view-to-see-the/m-p/474841#M7670</guid>
      <dc:creator>kynabaker16</dc:creator>
      <dc:date>2021-09-22T14:34:30Z</dc:date>
    </item>
    <item>
      <title>Re: Quick Tip: You can add a column to a project view to see the total number of issues in each project.</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/quick-tip-you-can-add-a-column-to-a-project-view-to-see-the/m-p/474842#M7671</link>
      <description>&lt;P&gt;Hi @Kyna Baker - inactive‚ &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Any recommendation, how can we add a condition such as to highlight with color if no. of issues are more than 1.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Also, condition such as only active issues for example.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Mvh&lt;/P&gt;&lt;P&gt;kundan&lt;/P&gt;</description>
      <pubDate>Thu, 23 Sep 2021 12:36:16 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/quick-tip-you-can-add-a-column-to-a-project-view-to-see-the/m-p/474842#M7671</guid>
      <dc:creator>Kundanism</dc:creator>
      <dc:date>2021-09-23T12:36:16Z</dc:date>
    </item>
    <item>
      <title>Re: Quick Tip: You can add a column to a project view to see the total number of issues in each project.</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/quick-tip-you-can-add-a-column-to-a-project-view-to-see-the/m-p/474843#M7672</link>
      <description>&lt;P&gt;Hi Kundan, &lt;/P&gt;&lt;P&gt;You can add a column rule to your totalOpTaskCount column, and do that in text mode to get those conditional formatting to show up. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;If you want to see the open issues, just use the Number of Open Issues field, which doesn't require text mode. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Kyna&lt;/P&gt;</description>
      <pubDate>Thu, 23 Sep 2021 21:21:15 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/quick-tip-you-can-add-a-column-to-a-project-view-to-see-the/m-p/474843#M7672</guid>
      <dc:creator>kynabaker16</dc:creator>
      <dc:date>2021-09-23T21:21:15Z</dc:date>
    </item>
    <item>
      <title>Re: Quick Tip: You can add a column to a project view to see the total number of issues in each project.</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/quick-tip-you-can-add-a-column-to-a-project-view-to-see-the/m-p/474844#M7673</link>
      <description>&lt;P&gt;@Kyna Baker - inactive‚ I am loving your Quick Tip posts! Keep them coming cause they have been helpful. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;I do have a question in using totalOpTaskCount. I will like to only count the issues in a project that have a Parent Topic Group. My client wants to know the % of issues that are arising from a specific topic group. In valueexpression= , I was trying to use an IF(&amp;lt;parentTopicGroup&amp;gt;="Problem",SUM.... but cant get it to work. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Thanks, &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Marco&lt;/P&gt;</description>
      <pubDate>Tue, 21 Dec 2021 12:26:37 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/quick-tip-you-can-add-a-column-to-a-project-view-to-see-the/m-p/474844#M7673</guid>
      <dc:creator>MarcoLu</dc:creator>
      <dc:date>2021-12-21T12:26:37Z</dc:date>
    </item>
    <item>
      <title>Re: Quick Tip: You can add a column to a project view to see the total number of issues in each project.</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/quick-tip-you-can-add-a-column-to-a-project-view-to-see-the/m-p/474845#M7674</link>
      <description>&lt;P&gt;@Kyna Baker - inactive‚ Thanks for this! It is very helpful.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;To go one step further, can I aggregate the average number of issues in a grouping? (by year and month, for example)&lt;/P&gt;</description>
      <pubDate>Thu, 06 Jan 2022 14:26:18 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/quick-tip-you-can-add-a-column-to-a-project-view-to-see-the/m-p/474845#M7674</guid>
      <dc:creator>CathyKe1</dc:creator>
      <dc:date>2022-01-06T14:26:18Z</dc:date>
    </item>
    <item>
      <title>Re: Quick Tip: You can add a column to a project view to see the total number of issues in each project.</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/quick-tip-you-can-add-a-column-to-a-project-view-to-see-the/m-p/474846#M7675</link>
      <description>&lt;P&gt;Hi Cathy,&lt;/P&gt;&lt;P&gt;I tried to ask people smarter than me for help and they had a couple of questions/thoughts. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;You can “group” by year or month, but that won’t give you an average. It will give you exactly all the issues in that grouping based on a date. For example, you can group on the Entry Date field by month and see groupings of all the issues with Entry Dates in the same month. But you're not going to see an average of anything.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Does that help? If not it would be nice if you could explain what you're trying to do in more detail. An example of a report you would like to see would be helpful so we can give some suggestions.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Thank you!&lt;/P&gt;&lt;P&gt;Kyna&lt;/P&gt;</description>
      <pubDate>Fri, 07 Jan 2022 21:01:18 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/quick-tip-you-can-add-a-column-to-a-project-view-to-see-the/m-p/474846#M7675</guid>
      <dc:creator>kynabaker16</dc:creator>
      <dc:date>2022-01-07T21:01:18Z</dc:date>
    </item>
    <item>
      <title>Re: Quick Tip: You can add a column to a project view to see the total number of issues in each project.</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/quick-tip-you-can-add-a-column-to-a-project-view-to-see-the/m-p/474847#M7676</link>
      <description>&lt;P&gt;Hi @Kyna Baker - inactive‚ I have created an Issues report that shows the number of Issues that were reported on Completed projects. &lt;/P&gt;&lt;P&gt;Filters: &lt;/P&gt;&lt;P&gt;Project&amp;gt;&amp;gt;Status = Complete&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Groupings:&lt;/P&gt;&lt;P&gt;Project&amp;gt;&amp;gt;Actual Completion Date (Year)&lt;/P&gt;&lt;P&gt;Project&amp;gt;&amp;gt;Actual Complete Due (Month of Year)&lt;/P&gt;&lt;P&gt;Project&amp;gt;&amp;gt;Name&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;It is showing me &lt;I&gt;only&lt;/I&gt; the projects that had issues filed on them, but what I really want is a report that will show me ALL completed projects, along with the number of issue that were filed on each project (which may be zero in some cases). From that, I want to calculate the Average Number of Issues for the completed projects, and be able to chart that. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;I envision it would look this screenshot, which is the chart from my Issues report, showing the total number of issues on completed projects - but instead of "Record Count" it would be the Average Number of Issues.&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0694X00000HCSHaQAP.jpg"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/45260iE56151D4882EA595/image-size/large?v=v2&amp;amp;px=999" role="button" title="0694X00000HCSHaQAP.jpg" alt="0694X00000HCSHaQAP.jpg" /&gt;&lt;/span&gt;&lt;/P&gt;</description>
      <pubDate>Tue, 11 Jan 2022 21:20:55 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/quick-tip-you-can-add-a-column-to-a-project-view-to-see-the/m-p/474847#M7676</guid>
      <dc:creator>CathyKe1</dc:creator>
      <dc:date>2022-01-11T21:20:55Z</dc:date>
    </item>
    <item>
      <title>Re: Quick Tip: You can add a column to a project view to see the total number of issues in each project.</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/quick-tip-you-can-add-a-column-to-a-project-view-to-see-the/m-p/474848#M7677</link>
      <description>&lt;P&gt;Cathy, thanks for the details you provided, they really help.  I got some more help from smarter people than myself!&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Here are some thoughts:&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;First of all, an issue report is based on issue objects. That sounds obvious, but here’s what it means for your report. Of all the issue objects that the filter allows to be a part of your report, additional information associated with those issues can be displayed. So the project name and actual completion date of a project is only available for issues that the filter lets into your report. Therefore, a project with no issues won’t have any issues to represent it in the report.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;What this means is that if you want to see projects with no issues you need to create a project report. There are a few good things about doing this.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;1. You can see projects with no issues&lt;/P&gt;&lt;P&gt;2. You can see the total issue count for each project&lt;/P&gt;&lt;P&gt;3. You can see the average number of issues per project&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Unfortunately, you can’t chart the average number of issues, but you can see the averages in the grouping bar. Here’s an example. Note that we are using the totalOpTaskCount field to get the total number of issues logged for each project. You’ll need to access this field using Text Mode.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0694X00000HCsxWQAT.png"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/45153i945FEAAD4FF5D54C/image-size/large?v=v2&amp;amp;px=999" role="button" title="0694X00000HCsxWQAT.png" alt="0694X00000HCsxWQAT.png" /&gt;&lt;/span&gt;&lt;/P&gt;</description>
      <pubDate>Tue, 18 Jan 2022 21:02:33 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/quick-tip-you-can-add-a-column-to-a-project-view-to-see-the/m-p/474848#M7677</guid>
      <dc:creator>kynabaker16</dc:creator>
      <dc:date>2022-01-18T21:02:33Z</dc:date>
    </item>
  </channel>
</rss>

