How create a report showing what tasks are scheduled to be done but are not started in a specific duration?

How create a report showing what tasks are scheduled to be done but are not started in a specific duration?

Suppose I have a table with following data:
Sample task history table
We need a pivot report which shows what are the tasks which were scheduled to be done but are not started in a specific duration.
For example, if max allowed delay to start a task is 15 minutes, then:
  1. if current time is 30 October 2023 15:30:00, then the report should show task 3 in result.
  2. If current time is 30 October 2023 15:50:00, then the report should show both task 2 and task 3 in the result.
We tried to build a query table and calculate difference between the scheduled time and current time with now() function. But this value doesn't update on refreshing the table.

How to make a report like this in Zoho Analytics?