How do i generate a report that will show monthly those employee who have no infractions.....say like perfect attendance for that month?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I need to generate a list of employees who have perfect attendance each month for a recognition event.

Photo of Myron

Myron

  • 0 Points

Posted 4 years ago

  • 0
  • 1
You will need to have a relationship where 1 employee has many infractions.

Then do a summary field Count on the left side of the relationship and make the filter where the infraction date is during the current month. Then copy that field and adjust the filter where the infraction date is during the previous month.

Now you can make reports of employees which have zero infractions in the current month and another report for EEs who have no infractions in the previous month.
Photo of Myron

Myron

  • 0 Points
I have no trouble finding 1 employee with many infractions. How do i start a field count on the left side of the relationship? And where do i find the ability to set the date range?
Click the button on the left side of the relationship to Create Summary field. It will let you set During the current Month. ( or Previous Montj)

Once you have your reports, then run the Report, click More, then Subscribe.