return correct total in response to make pagination possible bdf-query

[MarquiseRosier]

Description
currently a non-numerical total is returned,

To Reproduce
query rum-pageviews-bdf with an authorized domain key.

Expected behavior
total needs to be numerical like the limit parameter. so we can determine how much info is missing and we need to provide materials for folks to paginate.

Screenshots

issue raised by David Barrat of the DAAS team.

[langswei]

I believe this relates to #921 which needs to be merged first. Since a change would be required to the file named rum-pageviews-bdf.sql, I'd like to take the opportunity to move it to a folder ([email protected]) which also requires some work in the dash-queries branch to be merged.

[langswei]

RE: non-numerical values, that is likely due to https://github.com/adobe/helix-run-query/blob/main/src/util.js#L165-L166. My suggestion at this time is to not consider the offset and total fields as having any relation to pagination (which is not implemented at this time).