SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 How to use Standard Deviation in expression
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

arvi
Starting Member

Philippines
7 Posts

Posted - 01/17/2013 :  03:50:08  Show Profile  Reply with Quote
Hi,

I'm creating a quarterly report for email performance and I want to include standard deviation on the report.

Is it possible to use the StDev in expression given the figures per month?

-------------Sent------StDev
Email 1------4500-------???
January-----1000
February----1500
March-------2000

Email 2------4550-------???
January-----1300
February----1550
March-------1700

Email 3------5500-------???
January-----1700
February----1300
March-------2500


TIA

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 01/17/2013 :  04:06:55  Show Profile  Reply with Quote
you can use StDev() function in reporting services for that. make sure you pass scope correctly (month level or whatever grouping level you want)

http://msdn.microsoft.com/en-us/library/ms155807(v=sql.90).aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3661 Posts

Posted - 01/17/2013 :  04:10:21  Show Profile  Reply with Quote
STDEV and STDDEVP are available in SQL Server. STDDEV is for sample population (N-1 in the denominator) and STDDEVP is for entire population (or if you have a large enough sample and want to consider that as the universe (N in the denominator)).

I didn't quite get the structure of your data - so not sure what std dev you are trying to calculate - whether it is the emailN or whether it is months (aggregated) or something else.
Go to Top of Page

arvi
Starting Member

Philippines
7 Posts

Posted - 01/17/2013 :  04:24:31  Show Profile  Reply with Quote
thanks for the link Visha

but how can I include the group by Month in this expression?

=StDev(Fields!Sent.Value, "DataSet1")

When I compute in Excel , StDev for Email is 500.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 01/17/2013 :  04:29:49  Show Profile  Reply with Quote
you've added a grouping based on month in your report right? then you just need to pass month group name inside scope argument like below

=StDev(Fields!Sent.Value, "Month Group Name")

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000