Proof decision data

[JustinWa2]

Hello!

Need a report that shows a proof name, the approvers on each stage, and the time it took for them to approve the proof.  I've tried writing a couple of different document version reports, but I can't seem to find a way to capture the time it took to approve.  Any suggestions?

Thanks!

[MoniqueEvans]

If you make a document version report you can use the following code to show the wait time in business days for proofs still pending. If you want to show the wait time for proofs with decisions you'll need to modify the equation slightly so that the two dates are entry date vs decision date instead of entry date vs today.

displayname=Wait Time
shortview=true
textmode=true
valueexpression=CONCAT(ROUND(WEEKDAYDIFF({entryDate},$$TODAY),1)," Days")
valueformat=HTML

[JustinWa2]

This is awesome, thanks so much!

I can't seem to figure out how to write the code to try the entry vs decision date.  Would you know how that should be written?

[nryan2]

I' curious how you got the SOCD icons to display in the "Preview" column. Is that a standard field?

[MoniqueEvans]

No, we were proofing a screenshot of the buttons to have an example for a quiz question so that's the asset needed for approval.