Forum Discussion
Calculating Percentage Complete with monthly requirement
I apologize for the delay in responding...I had to remove sensitive data and re-create a basic copy of my file.
I have attached a link to my desktop file for viewing. This includes 2023 data with employees and supervisors. Upon inspection, you will notice that the requirement is 2 observations per month. Some employees do not meet requirement (with either 0 or 1 observation) while others go above the requirement and complete more. In calculating % complete, this alters the result sometimes showing that certain employees or supervisors are >100% complete.
- When filtering by employee, the greatest % complete needs to be 100
- When filtering by supervisor, those that completed more than the required 2 per month, only need to have 2 calculated in the equation so that they are not making up for those that did not meet requirement. I wrote a measure to try and resolve that by only counting 2 when the total observation count >=2, however it counts a static 2 in the totals. This measure also will not work when selecting more that just one month in the date slicer (for example a supervisor wants to view his team's results on meeting requirement for more than one month at a time.
Please let me know if you need further information to help and thanks in advance!! (I have been stumped on this for months!)
