0 Replies Latest reply on Jan 27, 2012 7:53 AM by Zachary Geis

    Issue with joining tables for Compliance

    Zachary Geis

      Hello,

       

      I am working on a dashboard for quality assurance at a mortgage processing company.  The dashboard shows the compliance scores as well as the top errors.  I've included a screenshot of the dashboard below.

       

      The problem is that I am unable to get accurate results. For every item on the dimension tables, it adds to the fact table.  For example, if I have two errors on one item, the item will show up twice in my data set.

       

      I've also included a spreadsheet listing a sample dataset.

       

      I'm not sure if I just don't have the data in the right format or if I am not linking them together properly.

       

      Any help is appreciated.  Let me know if you need more information.

       

      - Zak