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


      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)




      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?