% Of Submissions Passed through Steps in CSW
SummaryThis is an example report that shows the percentage of submissions that have passed through various CSW Steps.
The attached report highlights the use of the following formula to show how many submissions are progressing to selected steps.
ceiling (count(distinct case when "Submission CSW Status - Historical"."Historical Step Name" = 'Step' then "Submission General Info"."Submission Identifier" end) / "Candidate Counts"."# Submissions" * 100 )
The ceiling function is used to round decimals up to the next integer, for instance 9.1 will round to 10. To customize this report for use in your zone you will change the step in the formula -