I don't know reports really well (I don't come from a background where I have that experience so it's a struggle to figure out what people want to see in a report unless they straight up tell me). I have 2 charts that I created for one of our teams. Unfortunately they employ the use of custom fields, but that's sometimes how life is. The challenge was that the team wanted to see where the slippage was happening on specific tasks (look up Milestones
https://experience.workfront.com/s/global-search/milestones ) -- and they wanted to see this on a chart, not a report. So I created two calculated fields, which is sometimes the only way you can get a more visual report. This one (I called this field "Slippage") gets reported to a chart as an average, per milestone: WEEKDAYDIFF(Default Baseline Task.Planned Completion Date,Actual Completion Date) This has to be formatted as a number field, so don't forget that part otherwise you'll have to re-do it. It calculates the difference (in weekdays) between the actual completion date and the original (baseline) planned completion date, and the resulting chart shows different bars to denote different milestones so you can see which milestone has the biggest "average slippage." This next field gets reported to a chart and each milestone gets reported as either being late or not late: IF(Slippage<=1, "On Time","Late") The "slippage is less than, or equal to 1" part: basically if it's a day late we don't really care, right? (if you care, just make that number 0) So anything less than a day late is considered "on time." Otherwise it's late. Then this all gets reported on a bar chart as well, one bar per milestone and I stack them so I can see two colors per bar: one for the lates, and one for the on-times. Honestly, the thing that was the biggest pain in the neck was making sure the custom form with those two calculated fields would populate into every task we needed it to and making sure that no matter what we did, the calculations would faithfully update. (even now, I'm suspicious) -skye