Davis app trying to filter on weekdays only

Hello,

Is it possible to filter on weekdays within anomaly detection?

Or is the a DQL weekday filter for timeseries?

KR Henk

@henk_stobbe There is a getDayOfWeek function available in DQL that can be used with timeseries , but could not really get that working in anomaly detector …may be its not the right one to be used with AD

Here is a query in a very crude form in case you want to try and experiment

timeseries {CPU_Util=avg(dt.host.cpu.usage),e=end()},  by: {dt.entity.host},interval:1h
| fieldsAdd CPU_Util_WD = if( getDayOfWeek(e[])>=1 and getDayOfWeek(e[])<=5, CPU_Util[] )
| fieldsRemove CPU_Util