Dynamic Goals by employee title
I'm trying to set up a card to show employee performance against a corporate goal that is variable based on the employee title. Certain employees need to submit a report, and the # of reports they have to submit is either a certain number per day, per week, or per site visit, depending on their title.
I have one dataset that captures report submitted by employee and the date submitted, and another dataset that captures the goal definition and title (i.e. 3 per week | employeeTitle).
I'm not sure how to structure this dataset to determine if the goal is being met.
Has anyone done something similar to this, or have some suggestions of how to approach it?