I have items with statuses, and every item could change its status over time. But when I select status in table, it selects all items which had or have this status over time. How can I select only last value? I've tried to add visual level filter, but it didn't accept date field.
Example of how problem looks:
item_name had statuses status_1, status_2 but currently has status_3
item_name_1 had status_1, currently has status_2
item_name_2 had status_2, currently has status_1
When I click on status_1, it selects all three item names, but I want to select only status_1.