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”.