Calculated Total breaks when giving larger time span

For some reason, the “Totals” are not being added when I expand the time range
5m - 3hrs work after that it keeps disregarding data





Possibly because the Max data points and interval is changing?

how can I set the interval to have a way to be divided by how many seconds are in the interval? and have calculations keep working with the Max data points being restricted?





I also have an issue when 2 days of data it breaks
but then 7+ days it works again