Skip to main content
Insert Banner Message here.

Community

Search

Welcome to Community

Report for the Average Number of Review Workflows for a Subtype

Answered

Comments

4 comments

  • Graham G

    Hi Raphaël - here is one way you might be able to accomplish this:

    - create formula field using the function numTimesInValue(field, value) - field can be status and value can be value that the document would necessarily pass through

    - create a tabular report document report that groups by sybtype

    - add the formula field as a column - and select Avg for the calculation (these appear for number and date fields when groups are added)

    Another way you could accomplish this is by modifying your workflow to include an action that increments a document field each time it passes through a cycle.

    Let me know if you meet any challenges.

    Regards, Graham

    0
  • Raphael Goubet

    Thanks Graham. It looks like like the first solution is best designed for this purpose. However, we'll need to manage this as a formal change request as it will be a change in documents (pretty simple one, though).

    Will the calculated field yield results retrospectively for past cycles, or only from the time it's active?

    Kind regards,

    Raph

     

    0
  • Graham G

    Good question - it should yield results retrospectively as it leverages the audit trail for the calculations. 

    Regards, Graham

    0
  • Raphael Goubet

    Great, thank you Graham!

    0

Please sign in to leave a comment.

Powered by Zendesk