I want to fix "others."

version :3.14.1(on premise)

I want to solve the problem of Matomo showing “others”.
I have Matomo configured as follows to display up to 1000000 lines.

config.ini.php

[General]
datatable_archiving_maximum_rows_referrers = 1000000
datatable_archiving_maximum_rows_subtable_referrers = 1000000
datatable_archiving_maximum_rows_userid_users = 1000000
datatable_archiving_maximum_rows_custom_variables = 1000000
datatable_archiving_maximum_rows_subtable_custom_variables = 1000000
datatable_archiving_maximum_rows_actions = 1000000
datatable_archiving_maximum_rows_subtable_actions = 1000000
datatable_archiving_maximum_rows_site_search = 1000000
datatable_archiving_maximum_rows_events = 1000000
datatable_archiving_maximum_rows_subtable_events = 1000000
datatable_archiving_maximum_rows_standard = 1000000
archiving_ranking_query_row_limit = 0
visitor_log_maximum_actions_per_visit = 1000000
minimum_memory_limit = -1
minimum_memory_limit_when_archiving = -1

However, Matomo will only aggregate up to 100,000 rows, and after that, it will group them into “others”.

This problem was also found in “week”.
Is there any way to solve this problem?


Best regards.

After updating the configuration, did you invalidate the archived data?

thanks you for the fast reply.

This configuration is done during the initial build.
The archived data was created later, so there is no possibility of an “invalidate-report” issue.