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

    Issue with joining tables for Compliance

    Zachary Geis



      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