How do I show in a task report chart the tasks that were "late" and "on time"? | Community
Skip to main content
DianaTu
Level 2
Apr 28, 2021 10:33 PM UTC
Solved

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

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.
imgrund
imgrundAccepted solution
Employee
Apr 29, 2021 2:42 PM UTC

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.

View reply

6 replies

DianaTuAuthor
Level 2
Apr 29, 2021 2:44 PM UTC

Thank you! I've been going crazy trying to figure this out!

Translate
DianaTuAuthor
Level 2
Apr 29, 2021 2:34 PM UTC
No text available
Translate
imgrund
imgrundAccepted solution
Employee
Apr 29, 2021 2:42 PM UTC

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.

Translate
    DianaTuAuthor
    Level 2
    Apr 29, 2021 2:34 PM UTC
    No text available
    Translate
    DianaTuAuthor
    Level 2
    Apr 29, 2021 2:33 PM UTC

    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"

    Translate
    imgrund
    imgrund
    Employee
    Apr 29, 2021 2:14 PM UTC

    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. :)

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...