I need to show daily/weekly/monthly average of duration of my job with Gauge in Kibana.
We can call this graph as daily/weekly/monthly load percente of machine.
duration-time-in-day field in index. want to sum duration-time-in-day and divide with selected range in day.
For example; my date time selection field is
Jul 27, 2020 @ 00:00:00.000 -> Jul 28, 2020 @ 00:00:00.000
its a single day.
So that my requirement
or my other time filter selection
last 7 days
sum(duration-in-day for last 7 days) / 7
I try to use Bucket script may close for this. But i could not find to get the right way of the date range dynamically.
Any advice for this ?