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.