This is a public Forum  publicRSS

Topic

    Amber Hayes
    Problem with joins
    Topic posted September 11, 2018 by Amber HayesNewbie, last edited September 11, 2018 
    17 Views
    Title:
    Problem with joins
    Content:

    Hello,

    We are trying to create a report that brings back all of the client incidents in a specific time frame, by product and client. We are joining on tables SLAs, SLA instances, Incidents, Incident Performance. This report is extremely off. We thought by adding the SLAs back to tickets that did not have it filled would fix the issue, however, it is still not correct. For security I have removed the interface name, product names, and client_portid names. Attached you'll find the table information and what the report looks like when it has been ran. 

    Thanks in advance

     

    Image: