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.
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.