I am attempting to create a graph that shows a count of the number of transaction records per month for the current year displayed as a bar chart with a line graph overlaying showing the average number of transaction records per month over the past 5 years.
I have the current records per month working well however the 5 year average is not displaying properly. I've tried using a Moving Average calculated series and while it looks close the output doesn't match the numbers generated in Excel.
My dataset has the following columns:
The Bar chart data is derived with a Category group of Month with a Value of Month using the following expression:
=Count (IIF(Fields!TransactionDate.Value >= Parameters!StartDate.Value AND Fields!TransactionDate.Value <= Parameters!EndDate.Value,Fields!dateissued.Value,nothing))
Essentially, what I'm wanting to accomplish is an Average of the count per month over the 5 year period.
I'm pretty new to SSRS so any help you can provide is appreciated.