Running Totals in a Tasks Completed Report | Community
Skip to main content
December 19, 2024
Solved

Running Totals in a Tasks Completed Report

  • December 19, 2024
  • 1 reply
  • 1105 views

I would like a report to show me total number of tasks completed for the entire project duration ....summarized by month.   So if each month we completed 10 tasks, the report would show a bar of 10 for January, 20 for February, 30 for March, etc.    I've got the report built, but I only show totals for the month.... so 10, 10, 10.    How can I aggregate the total for the project at each month?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by KellieGardner

Thanks for trying.  Yes, burndown, but all the search results and analytics examples seem to be focused on planned vs. actual hours (different columns same filter criteria).

 

I should have mentioned that, since first posting, I have built a chart of monthly completions--see attachment.  But to add the second metric (as a combination report), I cannot figure out how to give a count of tasks open in each month.  The second challenge is how to use two different selection criteria or filters.  For the first, it's just status = completed.  But what does one do when they want another filter of status not= completed?  


The problem is you can't create a chart report that will count both planned completion dates and actual completions dates into columns. There isn't a real easy way to do comparison chart report in Workfront for dates.

 

One thing I was able to do was bring in the total task count for the project. However, the total task count does include parent tasks. 

 

 

 

Unfortunately, you can probably accomplish what you are looking for through a series of complicated calculated columns, fields, etc. but it won't happen natively.

 

1 reply

KellieGardner
Community Advisor
Community Advisor
December 19, 2024

I'm trying to visualize and understand what it is you want to see.

 

To clarify you are wanting the tasks completed in January to carry over into the count of tasks completed in February and January/February to carry over into task completed in March? 

 

 

EddieArAuthor
December 19, 2024

Actually i want to show individual monthly task completions side by side with total tasks NOT completed. I’ll paste a mockup here

EddieArAuthor
December 19, 2024
Picture1.png