Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kingdjango
Starting Member
2 Posts |
 Posted - 2008-04-17 : 13:51:14
|
| Hello Guys,Im quite new to SSRS and SQL in general and i've found this site to be a goldmine, and I found a thread on here relating to moving averages but I don't think it meets my needs.I have a simple bar chart in SSRS with a Category Field (Fields!WeekYear.Value) which has the week number and year value on the axis, and a Data Field (Fields!Amount.Value) which is just a quantity for the given week.Now what I need is a Moving Average of the amount with each new week generated (Simple and 3-point and/or 5-point), I've tried using some code and even functions but nothing is working for me so I was wondering if anyone here can help me out?PS I've been tinkering with the RunningValue function and my DataSet is called "Cube" so I assumed that the scope should be "Cube" aswell but it only returns an error, am I right or am I being retarded?As I say I am very new so please be gentle with me :)Thank You in advance.Man im a n00b! |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-04-17 : 15:56:56
|
| moved from New to SQL Server since it's better suited for SSRS dedicated forum._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
kingdjango
Starting Member
2 Posts |
Posted - 2008-04-18 : 07:52:54
|
| Yup Peso thats the one i saw, but it appears that it only works for a set amount of Catagory points, naturally as mine is week and year the scale could extend into infinity so i need something that will always work into the new week without manually changing the code.Correct me if im wrong tho.Man im a n00b! |
|
|
|
|
|
|
SSRS2K5 Moving Average