Standard Deviation

[#1]

hi all,

i have two fields, one being date and the other being tweet text.

I need to cal. standard deviation for number of tweets(count) over date.

Thanks

[sujeetsingh]

Here it is

http://community.qlik.com/thread/46850

\

Use fuction stdev (data)

[jagan]

Hi,

Try like this

Tweets:

LOAD

*,

1 AS TweetCount

FROM TweetData;

TweetsByDay:

LOAD

Date,

Count(TweetCount) AS TweetsByDate

RESIDENT Tweets;

Now in chart try like this

Chart :

Dimension: Date

Expression: Stddev(TweetsByDate)

Hope this helps you.

Regards,

Jagan.