Insights Query to Delete SBO does not seem to work

Hi Team -

We created a custom insight which tracks time for approval for our managers.

It works well and updates the counts of time for approval whenever an employee submits one. However, we noticed that when the manager already approves the time, counts are still the same. We're expecting it to be deducted by the transaction recently approved.

With that, we defined a Query to Delete SBO, so that whenever a manager approves or the employee decides to delete his time entry, after running the incremental index build process, the already approved entries will be removed.

It only worked partially. It only works for the part wherein the manager has approved the transaction. However, for the case where the employee deletes his submitted timesheet entry, it did not.