Ah but I guess you could have a large
Ah but I guess you could have a large variety of dates
11 Replies
in my scnerio its "leads" in a crm and i need to get counts of leads that were on each day
I would keep a separate table with date counts, one record per date, and update the record on patch/insert of the table you're referencing.
i see so
>how many were added per day
that way i can query by _creationTime
yep
didn't thought of that before. thanks G
you can do this sort of thing with any kind of aggregation, but depending on scale you may need to gather the data periodically rather than on every patch/insert
yeah i can schedule something i suppose
end of day. but i'll also have to worry about timezones :ahhhhhhhhh:
you could always add the ability to trigger a refresh too, if freshness on demand is needed
yeah but its literally on overview page on the dashboard every user visits it first after logging in lol
Ah I see
i think best would be that first thing you helped me think
š¤