Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
berryandcherry6
Creator III
Creator III

calculating standard deviation of Completion Time

I am trying to calculate standard deviation of subject Completion time.I am using combo chart where SD should be a line graph.

How could i calculate standard deviation ,Below i have attached qvf file.Please help me in this regard.

2 Replies
Gysbert_Wassenaar

I don't see a Completion Time field in your data.

In general the standard deviation is calculated using the stdev function: stdev(MyField)


talk is cheap, supply exceeds demand
berryandcherry6
Creator III
Creator III
Author

Here Completion Time is time_interval mentioned, which is taken as dimension.

Yes,if SD is calculated directly for each value at that time it will be helpful,but i need it to be found by taking count of user's into account.I mean i need to put a formula which contains number of users to calculate SD for each time_interval.