Select only buckets of working day

Hello,

I'm trying to calculate the average of documents by day (24h) for working days, i found that elastic calculate the average by this formula : avg = sum(docs of working days) / numberOfDays, and what i want is the next formula : avg = sum(docs of working days) / (numberOfDays - weekends).

my question is, is there a way to exclude weekends from the interval calendar ? or to delete buckets of weekends ?

Thank you

Hi,

As you said "formula", are you using Lens visualization of Kibana?
If so, I have no idea about filtering weekday by the formula itself.

One possible way is creating a day of week runtime field.
Here is also a hint.