search

tchapgouv / tchap-stats

Scripts et organisation des statistiques fournies à Metabase provenant des données matrix
2 stars 1 forks source link

user_monthly_visits isn't refresh automaticaly #24

Closed jdauphant closed 5 months ago

jdauphant commented 1 year ago

The command "REFRESH MATERIALIZED VIEW CONCURRENTLY user_monthly_visits;" isn't run at each import.

This don't run : https://github.com/tchapgouv/tchap-stats/blob/f2ca32d88226d99c1fd1f2ea5d96540b2ef93f11/scripts/insert_user_daily_visits_data.sql#L12

odelcroi commented 5 months ago

user_monthly_visits is deprecated, use https://github.com/tchapgouv/tchap-stats/wiki/Visites-Quotidiennes-des-Utilisateurs-par-Mois-sur-1-An-(%60user_daily_visits_by_month_1y%60) instead