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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2011-03-28 03:36 PM

Mean and standard deviation of accumulated data

Good afternoon,

I calculate the standard deviation using the following formula: Stdev( ALL aggr( COUNT(NumOco) , DataOco))

and the media with the following formula: Avg( ALL aggr( COUNT(NumOco) , DataOco)) ,

now my boss wants me to accumulate 365 days (or 12 months) before and I have no idea how would the formula.

To calculate 365 days earlier I use the following formula: Count(if(DataOco>(Today() - 365),NumOco))

Simply join the formulas??

Does anyone have any tips?

Hugs,

895 Views
0 Likes
0 Replies