Skip to Content
0
Nov 16 at 06:30 PM

SAC - count courses by employee and antiquity

97 Views

Hi experts,

I am trying to make a chart that shows only the most recent certifications of the workers. If a worker has more than one certification, it should only add up the most recent one.

The groups I have are:

- Updated (<5 years)

- Between 5 and 8 years

- Obsolete (>8 years)

- uncertified

Examples.

1.- If I have an up to date and an obsolete certification I should only add one to up to date.

2.- If I have one obsolete certification and one Between 5 and 8 years, I should only add one to between 5 and 8 years.

image.png

Do you have any idea how I could do it?

Thanks

Attachments

image.png (84.0 kB)