I am trying to get the last maintenance activity date and case number from a set of data for a selected date filter. Below example activity date filter is set to previous year 2024. but I am getting maximum date of 2025 from the dataset. for serial 14191 I should get 2024/02/20 12:15 and serial no 14892 I should get 2024/02/22 11:48, as highlighted respectively. since activity date is set to 2024, I shouldn't get maximum date of 2024, It should take the activity date into consideration.
@Michael Madisha
Hi, in this case add the filter to the context. Right clic the filter and select add to context. Remember order of operations, as context filters are applied befor FIXED LOD.
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador
