1 Reply Latest reply on Jul 19, 2017 3:13 PM by Peter Fakan

    Calculation to filter a 1 dimension list/viz based on its last state

    james.diaz

      I have seen many similar requests, but I need something that allows me to have only 1 dimension in the view, just a simple list, and 1 filter. The filter would be the calculated field.

       

      My data has three columns:

       

      status (state)

      email

      date

       

      There are emails with multiple records from different dates, with different states/statuses.

       

      I need to be able to produce a list of emails whose very last record is a specific state. So anything that is dependent on dates being included in the viz will not work for me. I guess it can be a calculated field or a set.

       

      Any ideas?