How to get sum on monthly basis for calculations?

[Max]

For a rolling 28 days can you do running sum?

runningSum - Amazon QuickSight

In regards to grouping your days to 28 you might look at this post for more information.

How to show datapoint at interval betwen second and minute?

I have data in a timeseries database where values are recorded every second. When displaying the data in graph I can filter time by minute or second.(on the x axis) Is there a way to let say display only a datapoint every 10 second. The reason is that the graph has a limitation of 10000 data points and I would like to be able to display a range bigger then 10000 seconds but 1 datapoint every minute is too much.