STDEV for count of incidents by week - qvw attached

[Anonymous]

I need to calculate standard deviation for the attached and show a line for 1 standard deviation above and below the average.  Any help is appreciated.

[hic · Accepted solution]

You need to create the week number in the script, and then create an expression

Avg(total Aggr(Count(DISTINCT Ticket_Number),[Week Number])) +

StDev(total Aggr(Count(DISTINCT Ticket_Number),[Week Number]))

HIC

[Anonymous]

This works but adding week number using DATEPART(wk,Opened_At) shows 12/31/2013 as week 53.  This is outside QV since my new issue is DATEPART issue.  Thanks!

[Anonymous]

Also, do you know why we can't do WEEK(Opened_At) in the AVG or STDEV function and week number has to come in during data load?

[swuehl]

You can try (edit: assuming Transact-SQL) using

DATEPART(isowk,Opened_At)

or use QV functions like Week() in a preceding LOAD:

LOAD

     Date,

     Week(Date) as Week;

SQL SELECT

     Date

FROM ...;

[Anonymous]

I was able to use cwk and data matched.  Thanks everyone!