Submit a request

Rule Designer - AVG aggregation

Completed
Avatar
'Diez Peña, Santiago'

The currently available aggregation types are:

SUM, COUNT, MAX, MIN

The feature request is to add the AVG function.

Because of the way Kepion writes the GROUP BY clause you cannot really perform an average without either resorting to writing a SQL query or adding a dummy value field with aggregation in addition to the value you actually want to average. 

If a custom expresion is added, using AVG (value) doesn't solve the issue because the generated query doesn't let you alter the group by clause. 

Thanks!

 

2

Comments

2 comments

Sort by Date Votes
  • Official comment
    Avatar
    Kepion Support

    Hi Santiago,

    Thanks for pointing this out, this is actually an easy addition we can do. I talked with the Product Team and they'll have this feature implemented in the next monthly release (end of this month).

    Thank you!

    Ian Britz

    Comment actions Permalink
  • Avatar
    Kepion Support
    • Edited

    Hi Santiago,

    We added this feature to the current version of Kepion. To download the software, please visit the SharePoint website!

    Thank you!

    Sincerely,

    Yurika Harada

    0
    Comment actions Permalink

Please sign in to leave a comment.