Page visits difference in amount based on date range used in Matomo

We have run into following problem while using Matomo (v 4.2.0).
If we check data for a chosen page between date range (example) 1st to 7th, 8th to 15th and 16th to 22nd and we will add up the views per week the sum will be different than from date range 1st to 22nd. It seems like when we check a long range Matomo is not adding up data correctly and the difference is quite significant.

Maybe someone run into the same situation ?

I have the same problem (tho in different metric)
the only solution to debug it is by profiling the sql queries.

Can you provide some example of screenshots?
Also, can you try to reproduce on https://demo.matomo.cloud?

Example:

Date range from 09/11/2021 to 26/11/2021 (dd/mm/yyyy)
Vists: 103
Unique Vists: 93

Week by week

Date range from 9/11/2021 to 14/11/2021
Vists: 103
Unique Vists: 93

Date range from 15/11/2021 to 19/11/2021
Vists: 29
Unique vists: 24

So already at this point (2 out of 3 weeks) there is issue with numbers if I check the same date range week by week I see I had more visitors then checking 3 weeks in one date range.

I was not able to reproduce this on the demo site. I wonder can it be something to do with traffic? If the traffic is high can this be the issue. Can alot of data impact Matomo in such a way, that calculating this on the fly becomes an issue for it ?. Currently we have it set it up according to https://matomo.org/docs/requirements/ Tracking 1 million page views per month or less. But maybe we should increase it ?