Milestone OTIF metric
Best Answer
-
In that case, you would use a helper column (can be hidden after setting up) with a formula that indicates whether it was on time or late.
=IF([Actual Date]@row <> "", IF([Actual Date]@row<= [Target Date]@row, "On Time", "Late"))
Then to get the percentage that are "On Time" you would use
=COUNTIFS([Helper Column]:[Helper Column], @cell = "On Time") / COUNTIFS([Helper Column]:[Helper Column], @cell <> "")
Answers
-
Do you have a date column for the target completion and another date column for the actual completion?
-
Yes sir
-
In that case, you would use a helper column (can be hidden after setting up) with a formula that indicates whether it was on time or late.
=IF([Actual Date]@row <> "", IF([Actual Date]@row<= [Target Date]@row, "On Time", "Late"))
Then to get the percentage that are "On Time" you would use
=COUNTIFS([Helper Column]:[Helper Column], @cell = "On Time") / COUNTIFS([Helper Column]:[Helper Column], @cell <> "")
-
Would you use the following to find the % On Time for Milestones (MR) only
=COUNTIFS([Helper Column]:[Helper Column], @cell = "On Time") / COUNTIFS([Helper Column]:[Helper Column], @cell <> "") AND COUNTIFS([MR]:[MR], @cell = "TRUE"
-
You would include that range/criteria set in both of the already existing COUNTIFS. You would not use a third COUNTIFS.
-
You are AWESOME thank you
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives