[Bug]: Expand “Others” section for Pages not working

[rjtbhatnagar]

What happened?

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.

Raised this in forums too (https://forum.matomo.org/t/expand-others-section-for-pages/55982), and got a suggestion to create a bug.

What should happen?

Expected behaviour : 'Others' should expand rows to a limit of 20000 rows for Pages section too.

How can this be reproduced?

It can be reproduced by following steps mentioned above in 'What happened' section.

Matomo version

4.13.3

PHP version

No response

Server operating system

No response

What browsers are you seeing the problem on?

No response

Computer operating system

No response

Relevant log output

No response

Validations

• Read our Contributing Guidelines.
• Follow our Security Policy.
• Check that there isn't already an issue that reports the same bug to avoid creating duplicates.
• The provided steps to reproduce is a minimal reproducible of the Bug.

[sgiehl]

Hi @rjtbhatnagar,

It's hard to evaluate if this is a bug or not based on your screenshots.
How many records does the table show if you are viewing it flattened?

Also please consider updating to Matomo 5. Even if this turns out to be a reproducible bug, that still exists, it won't be fixed for Matomo 4.