https://lemmy.ml/c/maliciouscompliance doesn’t exist. You probably meant https://lemmy.ml/c/maliciouscompliance@lemmy.world

The subscriber count is server-local (only counts the users from your server). I suppose it could theoretically be synchronized to be global, but it’s not implemented right now.

The source code for the aggregate community statistics can be found here, I believe: up.sql

create or replace function site_aggregates_activity(i text)
returns int
language plpgsql
as
$$
declare
   count_ integer;
begin
  select count(*) 
  into count_
  from (
    select c.creator_id from comment c
    inner join user_ u on c.creator_id = u.id
    where c.published > ('now'::timestamp - i::interval) 
    and u.local = true
    union
    select p.creator_id from post p
    inner join user_ u on p.creator_id = u.id
    where p.published > ('now'::timestamp - i::interval)
    and u.local = true
  ) a;
  return count_;
end;
$$;

Notice the u.local = true, ensuring that only local users get counted in the statistics.