Ashby Analytics
Building Custom Reports & Dash...
Ratio Reports
8 min
this document reviews building ratio reports in ashby overview ratio reports are commonly used to show the number of applications or interviews it takes to get a certain result (ie a hire, an offer, etc…) ultimately, ratios allow you to compare a segment to the whole a ratio report is a special type of segmentation report create a ratio report build a ratio report is a segmentation report that is visualized as a ratio go to reports and select build, then choose segmentation filters the filter section will determine what the whole of the ratio is for example, if you are creating an applications to hires ratio, total applications is the whole group by the field you should group by is the one that distinguishes the part of the whole you want to report on if you are not able to isolate just one segment or part, you will need to docid\ wjbhw3mnd 381wu1n8f x a ratio reports on a part of a whole the “part” that you are reporting on must be its own segment or group view options by default, you will see a pie chart confirm that the group you want to report on is its own slice of the pie then select single number chart, select the group you are reporting on, and update the show option to ratio untitled tutorial this video walks through how to build a ratio report looking at how many applications it takes to get a hire (the application to hire ratio) further reading when to create a calculated field before building the report, you need to ensure the segment you want to report on is defined and is one value in a grouping for example, if you want to create a ratio report looking at number of applications it takes to get to an offer, you need to ensure that one segment of the report is the number of applications that made it to offer if the segment you want to report on is defined by multiple values, you will need to create a calculated field that will allow you to isolate the segment for example, if you want to report on the ratio of phone screens that results in an applicant making it to onsite interview stage, the segment you need cannot be isolated by a single field common calculated fields for ratio reports reached onsite opportunity field furthest stage group reached is onsite and all stages after onsite had interview opportunity field interview is not empty/ unassigned example building a ratio report with a calculated field here is an example of a report that requires you to build a calculated field this video will walk you through how to build a report showing how many applications you need to schedule in phone interview to have an application reach offer stage faq w hy does my report show grouping no longer exists? this means that the group you have selected has nothing in it/is 0 since that group no longer has anything in it, a ratio result is not possible