I'm having an odd problem with Dashboard Designer. I created a very simple line chart to display a sum of invoices by month. It works great as you can see below. The department wanted, instead, to see the same chart, but instead of using the "invoice date" they wanted to see it by "payment received date". Both are date only fields in a small sharepoint list with only 25 items. The ONLY thing I changed was the field as you can see by the screenshot, but when I change it from one date field to another, the results are very different and it doesn't seem to aggregate by month.
I'm sure I'm doing something wrong, but has anyone else run across this, or could help me? I've tried created a completely new chart and get the same results. I would think I could switch that field back and forth and it should be easy.
Thanks in advance,