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.
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]))
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!
You can try (edit: assuming Transact-SQL) using
or use QV functions like Week() in a preceding LOAD:
Week(Date) as Week;
I was able to use cwk and data matched. Thanks everyone!
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?
Retrieving data ...