当前位置: 动力学知识库 > 问答 > 编程问答 >

Graph a Monthly average over past 5 years in SSRS

问题描述:

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:

  • Month
  • Year
  • TransactionNo
  • TranasctionDate

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.

Thank you.

分享给朋友:
您可能感兴趣的文章:
随机阅读: