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.

You can group timestamps in a calculated field. Here is the calculation that will group a timestamp to the 10 seconds:

group to ten seconds: addDateTime(-1 * (extract(‘SS’,{event_timestamp}) % 10),‘SS’ ,{event_timestamp})

Is that what you are looking for?

1 Like