9 Commits

Author SHA1 Message Date
simkir cda142b3d1 Update umami sql queries 2026-05-26 16:52:01 +02:00
simkir 5945146f3c grafana: Fix umami weekly users query sorting 2026-03-02 14:16:21 +01:00
mrtz f81a4b2732 treewide: Format with shellcheck, jsonlint and yamllint 2025-12-29 12:41:13 +01:00
simkir 877cc612a0 umami: View umami submit events from 2025-09-01
To see more submits in our dashboard
2025-12-03 08:54:46 +01:00
simkir fe8632f5ea Add analytics namespace in query helper script 2025-11-20 10:51:08 +01:00
simkir ee1e3c7405 Change sim count materialized view into just view
Not so heavy that we need to store the table, it can just be computed on
the fly.
2025-11-20 10:51:08 +01:00
simkir 9720de1a67 Fix umami drifter count queries
Have to fill in all possible groups and sim types before doing the
transpose to get the right table.
2025-11-18 18:15:31 +01:00
simkir 74600abddc Add the crosstab select used in grafana 2025-11-18 15:32:08 +01:00
simkir 87dd246d09 Persist umami sql queries and stuff 2025-11-18 15:24:36 +01:00