Create statistics based on the user activity logs

[stitch]

Many actions are logged, but the totals are not converted to statistics per month. These values can be useful when giving insights in the usage of the dashboard.

Some example data:

[stitch]

This is the query to do so:

select da.name as "account", verb as "action", count(*) as amount
from actstream_action
         inner join internet_nl_dashboard_account da on actor_object_id::int = da.id
where actor_content_type_id = 51
  and date(timestamp) > date('2024-01-01')
group by verb, actor_object_id, da.name
having count(*) > 30
order by action, amount desc;