Looking to create a measure that will calculate average number of issues closed divided by the number of assignees (for that day) for each agent.
- I understand I need to create a formula that will look something like this: (issues closed)/(number of assignees). What I’m struggling with is pulling the number of assignees as a dynamic number - for example, on Tuesday only 34 assignees are assigned issues but on Wednesday 36 assignees are assigned issues. Is there a way to capture this possible change?
Thanks!