Hi all, on our Matomo On-premise, the rows under various archived reports (Pages, Events, Downloads etc.) get automatically grouped into “Others” section after displaying the top 500 rows, which is the default behaviour. In order to expand rows from “Others", I followed the configuration mentioned under this article: https://matomo.org/faq/how-to/faq_54/ and performed the following steps:
1.Updated the config.ini.php file as per the article (setting maximum number of rows to 20000)
datatable_archiving_maximum_rows_referrers = 20000
datatable_archiving_maximum_rows_subtable_referrers = 20000
datatable_archiving_maximum_rows_actions = 20000
datatable_archiving_maximum_rows_subtable_actions = 20000
datatable_archiving_maximum_rows_events = 20000
datatable_archiving_maximum_rows_subtable_events = 1000
datatable_archiving_maximum_rows_site_search = 20000
datatable_archiving_maximum_rows_userid_users = 20000
datatable_archiving_maximum_rows_standard = 20000
2.Invalidated the report for a period of one week in February for which I want to see the changes:
console core:invalidate-report-data --sites=1 --dates=2024-02-05,2024-02-11
3.Archived the report again using raw data for that one week period:
console core:archive —url= --force-date-range=2024-02-05,2024-02-11 --force-idsites=1
It seems to have worked as I can confirm seeing 20000 rows under ‘Behaviour → Events → Event Names’ section,
but it doesn’t work for ‘Behaviour → Pages’ section, which we actually want.
Any help would really be appreciated, thank you.