Nice to know about using arraySize in DQL

[henk_stobbe]

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

@MarcZ 

[henk_stobbe · Accepted solution]

FYI found this:

https://docs.dynatrace.com/docs/discover-dynatrace/platform/grail/dynatrace-query-language/commands/...

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