I'm trying to create a Platform Analytics dashboard that shows the requested items and how many of the requested items missed their sla vs met their sla. I want to use the Catalog Item's name as a filter (for example, iPad, Corporate Mouse, Retire a Virtual Machine, etc). The sc_req_item table doesn't show the sla for the task, but the task_sla table does. The problem is the sc_req_item doesn't have the "Has breached" column, that column is in task_sla. I want to connect them but in the task_sla table, I can't dot walk. In the task_sla table, it shows the RITM number but doesn't show the catalog item it came from. I don't have any elevated privileges such as system administrator. I only have basic user access. Any help is appreciated.
