Need help creating a calculated field to determine TAT | Community
Skip to main content
D
DawnSc
Level 2
July 24, 2024
Question

Need help creating a calculated field to determine TAT

  • July 24, 2024
  • 2 replies
  • 2113 views

I am trying to create a calculated field in a custom form that will show me the average turn around time form Project Initiation To Approved Go Live date on all completed projects.  I cannot figure out how to get two expressions in the calculated field.  I know one would be DATEDIFF({DE:Approved Implementation Date},{DE:Project Initiation Date})

but I don't know how to add the expression to get the average.  Any suggestions?

2 replies

skyehansen
Community Advisor
skyehansenCommunity Advisor
July 24, 2024

You cannot create a calculated field in one project form that will search for other projects in the system and then run math to calculate an average over all. I think you're thinking about a report, in which case, you would create a column for your turn time, set it to Average, and then group by that column.

D
DawnScAuthor
Level 2
July 24, 2024

I have the Ave TAT calculation in the report however, because it is a text mode field, I cannot group by that column and the report is to provide Ave TAT by project size year over year.  Everything I read states that in order to group in a report, it has to be a field in a custom form.  Any suggestions how I can create a report with Average TAT by project size if I can't group by the column because it is a text mode field?

D
DawnScAuthor
Level 2
July 24, 2024

You created a calculated field to replace your text mode column. Group by that calculated field, the single turn time for that project.


Tried that but it isn't working.  Thanks for your suggestions.  

S
Sujatha_TS
Level 4
July 25, 2024

hi, 

I do this using actual start and actual completion time - 

field name - Turn Around Time --> formula to be used  --> Round(DATEDIFF({actualCompletionDate},{actualStartDate}),2)
You might want to try using Round(DATEDIFF({DE:Approved Implementation Date},{DE:Project Initiation Date}),2)
 
I also do the grouping to show these in charts using this formula - 
IF({DE:Turn Around Time}<5,"<5 Day Turnaround",IF({DE:Turn Around Time}<=10,"5-10 Day Turnaround"))) add as much as grouping you might want. 
 
hoping this helps. 
    quarkmage
    quarkmage
    Level 3
    October 17, 2025

    @sujatha_ts 
    Thanks for the additional suggestions.  i am trying to implement some TAT analysis into my current reporting but am not well versed in the programming and text mode.  Are you using the rounding function to create some time buckets? i am not sure how granular a calculation field between two dates gets.

    For your TATs are you creating a calculation field formatted as a number, and providing the text-based program in the Instructions field?

     

    Thanks for any discussion and support.

    Terms & ConditionsAccessibility statement

    Loading footer...