Is there a way to report on tasks that are complete, but have no actual hours submitted? | Adobe Higher Education
Skip to main content
J
Justin_Charles
Level 3
August 23, 2022
Domanda

Is there a way to report on tasks that are complete, but have no actual hours submitted?

  • August 23, 2022
  • 3 risposte
  • 1530 visualizzazioni

I was able to create a report showing completed tasks that have 0 actual hours logged on the task.  However, if there is more than 1 person on the task and only 1 of them submits time, the other person's missing time would not populate on this report.  Is there a way to report out on Timecards that have completed tasks with missing actual hours?  Or do you have any other ideas?

 

Thanks in advance!

Questo argomento è stato chiuso alle risposte.

3 risposte

skyehansen
Community Advisor
skyehansenCommunity Advisor
August 23, 2022

it sounds like you would just want to use an Assignments report in the same way (with the difference being that rather than reporting on completed tasks, you're maybe reporting on completed tasks with zero actual hours per assignment (not per task)).

J
Justin_CharlesAutore
Level 3
August 23, 2022

What would the column be that would show you that a user didn't enter any actual hours?  When you use Task > Actual Hours, when 1 person adds time to a task, it shows time on the task for all users on that task.

skyehansen
Community Advisor
skyehansenCommunity Advisor
August 23, 2022

ah, bummer! Was hoping that would work. OK I'll keep thinking.

GrahamJarrett
GrahamJarrett
Level 4
August 23, 2022

Have you thought about doing a report with collections and the column being assignments and then using an IF statement in the valueexpression to include the name as "" of the assignee if they have time but their name if the actual hours = 0

J
Justin_CharlesAutore
Level 3
August 23, 2022

Graham- thanks for your reply.  Unfortunately, this terminology is a bit over my head.

 

What would the subcategory of the assignments column?

ElliotLeson
ElliotLeson
Level 3
August 23, 2022

Assignment Report

 

J
Justin_CharlesAutore
Level 3
August 23, 2022

Elliot- thanks for your reply.  That is essentially what I have set up right now, but the issue with that is if 1 person submits time on a task that includes multiple people, the task falls off the report even though the other people on the task may not have submitted any time.

L
LindaKe
October 4, 2022

displayname=Actuals by User
listdelimiter=<div>
listmethod=nested(assignments).lists
textmode=true
type=iterate
valueexpression=CONCAT({assignedTo}.{name}," - ",({actualWorkCompleted}/60)," Hours")
valueformat=HTML

 

Insert the above to review actuals x User

Termini e CondizioniAccessibility statement

Loading footer...