topic Re: Nice to know about using arraySize in dql in DQL

Nice to know about using arraySize in DQL

henk_stobbe — Thu, 06 Nov 2025 14:11:34 GMT

Hello,

May be I am mistaking but when in timeseries using a statements like:

| fieldsAdd newField = arraySize(' ')

It looks like there is a hard limit of 1500. DQL changes the interval to keep below this number....

So as an example using an interval of 1 minute: 24 hours will be 1440 (minutes/points)

but 26 hours will give 780 (two minutes/points)

KR Henk

henk_stobbe — Thu, 23 Oct 2025 09:34:08 GMT

FYI found this:

The nominal time interval, whether coming from the bins or interval parameter, is adjusted so that:

The time interval matches a well-known interval (1 minute, 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 1 hour)
The time interval does not exceed the maximum number of elements per series (1,500).

KR Henk