2 Replies Latest reply: Aug 16, 2016 8:55 AM by Janis Juris RSS

    Filter rows in straight table / chart by aggregated value

    Janis Juris


      I am trying to filter out rows with a particular row-id, row-id itself is produced via aggr formula:

      AGGR(nodistinct min({<[Comment number]  = {">1"}> } [comment-id] ),[Ticket number])


      A bit about columns

      [comment-id] - unique identifier of the row

      ,[Ticket number]) - object I am working with, it can be considered invoice number with [comment number] being items

      [Comment number]  - sequence number of a comment within [Ticket number], each ticket has its comments numbered 1 to n, I have to exclude the first and find the lowest second value. I might not be 2 as rows might be filtered out by other filters.