How do I show in a task report chart the tasks that were "late" and "on time"?

Forum|Forum|4 years ago
April 28, 2021
5 replies
3181 views

I'm working on a task report and wanting to show in a chart the tasks that were "late" and "on time". My groupings are 1) Project >> Name and 2) Task >> Project Status. Left (Y) axis on the chart is 'Record Count" and bottom (X) axis is "Project Name". The chart results for all the projects are 36 for all the projects, there's nothing for "On Time" or "Late". There are completed tasks in the projects that are past the due date. The other issue is that the Days late are all "0" even when the task completed weeks after the due date. What am I doing wrong? :(

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 imgrund

Hi - I would talk to Support. Something isn't right. When I put those dates in my instance I'm seeing Late for Progress Status.

imgrund

Adobe Employee

Hi @Diana Tucker‚ - Are you just looking at completed tasks? You might want to try grouping by Project >> Name and then Task >> Progress Status. When an actual completion date is put on a task, the projected completion date matches that. That means the Progress status is either Late on On Time. You can then do your chart to be by project name, click "Group Bars" and then select Stacked to show Late and On Time (you can also customize the color).

If you are including all tasks, note that Behind and At Risk will also show up as well.

This is the easy way to do it. There is also some tricks with calculated fields on custom forms. And even one with custom columns in a report but that requires text mode so you can't do a chart (just a list with groupings).

Hope that helps. :)

D

DianaTuAuthor

Level 2

Hi Anthony,

Thanks for responding.

My only filters are the projects I want to see. My groupings are as you suggested, in that order. I have task completion dates that are past the Planned Completion date, yet the tasks still show "On Time". A couple of images are attached. Please note the "Days Late" are all "0"

D

DianaTuAuthor

Level 2

No text available

D

DianaTuAuthor

Level 2

No text available