makeTimeSeries

dynacondused — Tue, 29 Jul 2025 07:24:46 GMT

Hi, trying to use makeTimeSeries but it doesn't seem to allow the success field I added below

fetch bizevents
| filter eventType == "my-event"

| makeTimeseries {
started = countDistinct(if(pathname == "/started", clientIPAddress), default: 0),
completed= countDistinct(if(pathname == "/completed", clientIPAddress), default: 0)

success = (completed/started) * 100}
| fieldsRemove started, completed

Re: makeTimeSeries

Cameron-Leong — Mon, 28 Jul 2025 16:42:33 GMT

Hello,
In order to create a new field that charts completed/started over time, you'll need to divide each value of completed by the corresponding value in started, which can be done using iCollectArray.

fetch bizevents
| filter eventType == "my-event"
| makeTimeseries {
       started = countDistinct(if(pathname == "/started", clientIPAddress), default: 0),
       completed= countDistinct(if(pathname == "/completed", clientIPAddress), default: 0)
 }
| fieldsAdd success = iCollectArray(completed[]/started[])
| fieldsRemove started, completed

topic Re: makeTimeSeries in DQL

makeTimeSeries

Re: makeTimeSeries