However, the numbers for hires per quarter is incorrect. My event type = "hire" contains existing employees, new hires as well as hire date of termed employees. So, I am finding it difficult to write a formula which would just give me hires for the current quarter from the event type = "hire".
Attaching my workbook for the same. Help appreciated! Thanks!