aggregates

srinu

• September 18, 2007 00:00

• Answered

Follow

how to calculate std dev() and median in clover and i used aggregate componenet to calculate sum(),max(),min() and i got the result and stddev() i am not getting the result and how to use stddev()? and there is fuction to calculate median.

IS THERE ANY EXAMPLES IN CLOVER BY USING STDDEV AND MEDIAN

please help me


srinu

• 

  jurban

  • September 18, 2007 07:50

  0

  Comment actions Permalink

  Hi,
  which version of clover are you using. In the 2.2 version, the aggregate component was updated (the aggregate documentation on the wiki is out of date, that will be fixed). The stddev() function should work, e.g.:
  
  $ouput_field:=stddev($input_field)
  
  Please note that standard deviation cannot be computed from one value. So in case that some aggregation group (defined by the aggregation key) has only 1 member, the standard deviation of any field of that group is null.
  
  could you please post the clover graph you are trying to run? Or at least post the aggregation mapping of the aggregate component.
  
  The aggregate component does not have a median() function, but that seems to be a great idea!
  
  Thanks!
  Jaro

Please sign in to leave a comment.