About andreaswpv

andreaswpv · ‎08-24-2021

Thanks, that works. Now I understand this - this is making two separate 'fields' based on the condition, to avoid having the calculation either in the eval, or in the stats (which both don't work).

andreaswpv · ‎08-24-2021

Hi need to calculate the average based on a condition. testing=true vs testing=false (lets say field A) field B has the values to average (milliseconds) field C has urls something like this: | stats avg(fieldB, when field A testing true) as trueV avg(fieldB, when field A testing false) as falseV by Field C Goal is a table like this: url | average (true) | average( false).

andreaswpv · ‎04-24-2020

so, this post is swallowing some characters when being published, as it actually had 5 positions in the cron . Let's try again (this time correct): Zero eleven asterix asterix five 0 11 * * 5

andreaswpv · ‎04-23-2020

Posts	4
Solutions	0
Karma Given	3
Karma Received	0
Member Since	‎11-10-2016

Online Status	Offline
Date Last Visited	‎06-08-2022 10:51 AM

conditional average

Re: conditional average

conditional average

Re: How to cron schedule for a specific time range...

Re: How to cron schedule for a specific time range...