topic Re: Display number per category in App Development

Display number per category

Itay113 — Tue, 04 Feb 2025 10:35:19 GMT

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

Re: Display number per category

Qrishna — Wed, 05 Feb 2025 14:34:13 GMT

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?

Re: Display number per category

Chanty4u — Wed, 05 Feb 2025 18:32:44 GMT

Try this

Count({<

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

>} name)