Results 1 to 4 of 4

Thread: Aggregated Averages

  1. #1

    Question Aggregated Averages

    Hi,

    I have some problem with using avg(). I need to get an average of a column by groups of other column. But it seems like avg is not a group function to use in LAE. I've attached a brg about this issue(avg1 is not equal to avg2). Can you please correct me if i am mistaken.

    Thank you

    Kind regards

    Ozgun

    Aggregated_average.brg
    Last edited by Wizardous; 01-08-2013 at 02:20 PM.

  2. #2

    Default

    Hi!

    I think you are correct and you need to use your avg1 approach.

  3. #3
    Contributor
    Join Date
    Dec 2006
    Location
    Boston
    Posts
    485

    Default

    Yes, that it correct, you want to implent as avg1. The function avg takes the average of all the parameters passed into it; if you pass a single argument, it will always return that. What you are looking for would be groupAvg, which isn't currently implemented.

    To help avoid this confusion, in future versions of the LAE, we are introducing new names, groupSum and groupCount, and will encourage their use over the current sum and count; hopefully this will help clarify that distinction.

    Cheers
    Rich

  4. #4

    Default

    Thank you for this information Rich and aop.

    Regards

    Ozgun
    Last edited by Wizardous; 01-10-2013 at 01:13 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •