1 of 1 people found this helpful
I believe your issue is with this statement:
max(APM_ApplicationStatus.[TimeStamp]) as [Month],
This results in it setting the current application status time as the Month. If you set it to:
max(APM_ApplicationStatus.[TimeStamp] -1) as [Month],
for example, then your report would show it as January 31st (since that's the max application status for last month).
I am not exactly a SQL expert so I'm not sure what the preferred method of updating your time stamp would be, but perhaps checking some other monthly reports might give you a better show for it or dropping that field entirely. It seems like the rest of your statements get the desired results, but this Month field is the one that's misleading.
Awesome, that did the trick.
I did try to compare to other reports with the same. But none of them actually displayed the Month column.