2 Replies Latest reply on Oct 3, 2016 5:59 AM by Andrew Watson

    Filtering Data Used in Aggregate Function

    Islam Ameen



      I'm having posts, and each post is joined with replies.

      I want to calculate the Average replies for a post.

      So the calculation = Countd(reply_id) / Countd(Post_id)


      That's working fine so far.


      What I want is to filter the posts used in this aggregate.

      It's like I want to calculate this average only for posts with 5 replies or more.


      The problem: If I used a filter Countd(reply_id) > 5, it counts all the replies on the Datasource, not for each job


      How can I do that?