I have a dataset with different id's and timestamps for when each id passes a step (there are around 100 steps). I would like to add a filter for the timestamp but I only want it to be applied on one step. I would for example want all the id's that have passed step 2 the last hour and see when they passed step 1. When I add a time filter for the last hour I get all the id's that have passed step 2 the last hour, but only the timestamp for the first step if they also passed the first step the last hour. How do I solve this problem? I would ideally find a way to only apply the filter to one step.
Could you please share the mock-up data/workbook.