30 Day Daily Average Gauge

Hi! I am having some trouble setting up a gauge accurately for a visualization in Kibana. I want to display a Daily # of orders that is sold over a 30 day period. My variables are 'order_qty' and 'date' for the timestamp. I have 'date' set up as a date filter currently, so I normally set the date filter in the top right of Kibana to the last 30 days.

You can do this using aggregation based visualization with "average bucket" like this:

Got it. What about this second metric 'bytes' at the bottom you have? Why is it set to a sum?

This is the metric to calculate the average day for. I just set to to an example - in this case it would give you the average total sum of bytes per day.

Example - consider follow documents:

  • Day 1 - 10 bytes
  • Day 1 - 5 bytes
  • Day 1 - 12 bytes
  • Day 2 - 3 bytes
  • Day 3 - 7 bytes
  • Day 3 - 8 bytes

Daily buckets will look like this:

  • Day 1 - 27 bytes (10+5+12)
  • Day 2 - 3 bytes (3)
  • Day 3 - 15 bytes (7+8)

Average bucket: (27+3+15)/3 - 15 bytes

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.