I have a set of data with "submit date" like "2019-Jan-16 17:42:00". How can I get data submitted before 14 Business days? Thanks!
Hi Try this simple query
index=your_index latest=-14d@d earliest=0 NOT (date_wday=saturday OR date_wday=sunday)
let me know if this helps!
do you want all data older than 14 days , or the data that came in on the 14th day before today?
I want the number of all data older than 14 Business days. thanks!
try index=your_index latest=-14d@d earliest=0 | stats count
index=your_index latest=-14d@d earliest=0 | stats count
for a simple count
Does "latest=-14d@d" mean last Business days? or last natural days? thanks!