We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

Filter Active Incidents where ALL Incident Tasks are Closed

licmartinez
Kilo Contributor

7 hours ago

Hi everyone,

I need help setting up a filter or report for the following use case:

  • Goal: Show Active Incidents where ALL associated Incident Tasks are Closed.

  • Condition: If any Incident Task remains open, the Incident must be filtered out.

Example:

  • Incident A has 2 Tasks (1 Open, 1 Closed)  Filtered OUT

  • Incident B has 2 Tasks (2 Closed) Included

I saw previous suggestions from @ajmalmuhamm and @Tanushree Maiti mentioning this might not be achievable natively, and many older workaround threads seem outdated now that we are using the updated Platform Analytics interface.

Has anyone successfully implemented this logic in Platform Analytics recently, or is there a recommended strategy (e.g., script, related list condition, or database view) to achieve this?

Thanks in advance for any insights!

0 Helpfuls
  • 81 Views
1 REPLY 1

Kieran Anson
Kilo Patron

an hour ago

Hi,

This is achievable using a related list condition which can be achieved in scripts using an RLQuery, or via platform analytics via the related list condition section.

 

Have you tried these? You've mentioned the related list condition. Was that insufficient?

0 Helpfuls