I did some searching and didn't find exactly what I was looking for. I also tried a couple things to get a step into accomplishing this type of dashboard, but no luck.
I basically want a dashboard that has counts for the amount of times a field is a duplicate in a list. I initially want to be able to filter this data by date and then sort it based on a couple other criteria. In the image below, PCID is one of them. I added a separate field in the list that combines the Part and PCID into one field so that it doesn't only count the PCID number, as this is an id for a measurement that needs to be done. So every part number would have a PCID with the number 1, as that is the first measurement that is required to verify the part is correct.
In the screenshot, I added a quick table of kinda how I want it to display. The filter and sort by Date section works fine. Any ideas or suggestions on adding the count functionality would be helpful. Thanks ahead of time.
