notes on how to add person counts

[javier-gracia-tabuenca-tuni]

https://chatgpt.com/c/6853bae1-3200-8011-a621-03d8024e0095

create atomic count for the source codes
source code | n events | HyperLogLog*1024

create (or calculate) descendants including source codes
ancestor | descendant | maps to

Given the root code
1- find parent, decendants, maps to
2- use above tables to calculate a table
node | mapsto/descendant | n events | HyperLogLog*1024

for source values remove first column
for node descendats group by node maps to + descendatna
for node counts only maps to