Need to get only latest record for each combined_id in Pie Chart
In Pie Chart (Donut), my Dimesion is job_status which has values SUCCEEDED,RUNNING,KILLLED,FAILED
my measure should be count of combined_id ,where timestamp=max(timestamp) group by combined_id, so i will get only the latest record for each combined_id
i dont want to implement in Load editor because there is timestamp filter pane if that changes it doesnt give the latest record for that combined id on the selected date range in the filter, so i need to implement in Pie chart
combined_id | timestamp A | 2023-07-31 15:33:16.66666 A | 2023-08-01 20:33:16.66666 A | 2023-08-01 05:33:16.66666
need A | 2023-08-01 20:33:16.66666 i have tried Count({<timestamp={"=max(timestamp)"}>}combined_id) Count({<timestamp={"=aggr(max(timestamp),combined_id)"}>}combined_id)
Doesnt work, if i do this i am not getting the latest record for each combined_id (please dont give max(timestamp) group by combined_id and then Left join--> this is for all the data, then it wont be right if i applied any filters for a particular range of date)
