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.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 How to use Standard Deviation in expression

Author  Topic 

arvi
Starting Member

7 Posts

Posted - 2013-01-17 : 03:50:08
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

52326 Posts

Posted - 2013-01-17 : 04:06:55
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
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-01-17 : 04:10:21
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

7 Posts

Posted - 2013-01-17 : 04:24:31
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

52326 Posts

Posted - 2013-01-17 : 04:29:49
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
   

- Advertisement -