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

    Filtering Data Used in Aggregate Function

    Islam Ameen

      Hello,

       

      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?