Level 1
Level 2
Melden Sie sich an, um alle Badges zu sehen
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? :(
Gelöst! Gehe zu Lösung.
Anhand von Themen werden Community-Inhalte kategorisiert und Sie können so relevanten Inhalt besser finden.
Zugriffe
Antworten
Likes gesamt
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.
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. :)
Zugriffe
Antworten
Likes gesamt
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"
Zugriffe
Antworten
Likes gesamt
Zugriffe
Antworten
Likes gesamt
Zugriffe
Antworten
Likes gesamt
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.
Thank you! I've been going crazy trying to figure this out!
Zugriffe
Antworten
Likes gesamt
Zugriffe
Likes
Antworten
Zugriffe
Likes
Antworten