XQL Widget to Exclude Weekends

[thenetworksfine]

Is there any way to exclude weekends from XQL query results?

[jmazzeo]

Hi @thenetworksfine, thanks for reaching us using the Live Community.

You can exclude the weekends only if you choose the starting and the ending date using the "config timeframe" stage, or from the visual menu in the query editor.

Any other option uses continuous days.

If this post answers your question, please mark it as the solution.

[mavega]

Hi,

You can run the script and modify the dates either on the top right corner on the query builder or using the config timeframe setting as explained on the link below:

https://docs-cortex.paloaltonetworks.com/r/Cortex-XDR/Cortex-XDR-XQL-Language-Reference/timeframe

Please mark as solution if this resolves your doubts.