topic Re: Divide each value by a specific number in an array - DQL in DQL

Divide each value by a specific number in an array - DQL

badgerfifteen — Sun, 07 Jul 2024 18:05:09 GMT

I have the following DQL query:

timeseries interval: 1d, usage = sum(dt.billing.full_stack_monitoring.usage), from: -7d, to: now()

Essentially, what I want is to divide each value within the array by a specific amount which would then give me my costing under the DPS model.

What DQL function do I use to divide each value within an array

Re: Divide each value by a specific number in an array - DQL

Maheedhar_T — Sun, 07 Jul 2024 19:56:56 GMT

Hi @badgerfifteen
iCollectArray is the function which allows iterative operations on the Arrays in DQL.
In your case something like this would help

timeseries interval: 1d, usage = sum(dt.billing.full_stack_monitoring.usage), from: -7d, to: now() | fieldsAdd actual_usage=iCollectArray(usage[]/100)

Just dividing by 100 here to give an example.

Regards,
@Maheedhar_T