Setting up workflow approval based on absence duration

Summary:

We have a requirement where the approval workflow needs to change based on the existing total absence duration for a specific absence type for an employee within a month.

E.g. If its 1 day leave then leave request will only go to Line Manager for Approval. But if employee applies for 1 day leave which takes the total absence count for this employee to more than 1 in a month, then 2 levels of approval are required for this leave request. So we need to change the approval workflow based on the total absence duration for this employee in a month.

Is this possible to check the duration for a specific absence type within the approval rule set up ? We can drive the approval based on a certain duration but here the ask is to first find out the total duration from the databased and then based on the current duration set up the workflow approval.Can anyone guide us if this is feasible ?