Welcome to the Make community!
Yes, that is possible. You’ll need a minimum of two modules:
This is just an example. Your final solution may or may not look like this depending on your requirements.
1. Iterate employees array
2. Aggregate (Count) by status
Sample output
Hope this helps! Let me know if there are any further questions or issues.
Note: I see hundreds of posts, notifications, and messages daily on this forum, so if I missed your reply, please message me to look at your reply.
— @samliew
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!