Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Please help me on this
Thanks in advance
Its working
how to show only the records which has count 1 in the table chart
and can you explain the expression too
like why it doesnt work before