Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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
Partner - Champion III
Partner - Champion III

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.