Display number per category

[Itay113]

I have a table with these columns: name, category, status, dtime. I want to get number of notActive status per category for each name his latest status even if I filter specific dtime and latest name’s status dtime is before filtered dtime. For example name - jack, category - worker, status - available, dtime - 2025-01-19 20:00:00, name - jack, category - worker, status - unavailable , dtime - 2025-01-19 21:00:00, name - mike, category - worker, status - available, dtime - 2025-01-19 20:00:00. So if I filter to 2025-01-19 21:00:00 I want to get category - worker, status - unavailable, number - 1
category - worker, status - available, number - 1

[Qrishna]

didnt really get what you are trying to achieve here. all i see is when you select 2025-01-19 21:00:00, you selecting that particular row, so the output is what you mentioned here. so you'll see category - worker, status - unavailable.not sure where number - 1 came frfom?

[Chanty4u]

Try this 

Count({< 

    dtime = {"=dtime = Max({1} Total <name> dtime)"}

>} name)