\ **Category:** Metrics\ **Created:** [October 6, 2022, 11:06am UTC](https://discuss.elastic.co/t/kibana-visualization-need-a-solution-to-get-range-average-utilization-min-max/315955 "2022-10-06T11:06:01Z")\ **Posts on this page:** 5\ **Page:** 1

**Author:** ![Lakshmi\_Narayana\_Red](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lakshmi_narayana_red/32/111740_2.png) [@Lakshmi\_Narayana\_Red](https://discuss.elastic.co/u/Lakshmi_Narayana_Red)\ **Post date:** [October 6, 2022, 11:06am UTC](https://discuss.elastic.co/t/kibana-visualization-need-a-solution-to-get-range-average-utilization-min-max/315955/1 "2022-10-06T11:06:01Z")

Hi Friends, We have a list of machines with and it's data like date, names, and utilization as mentioned below: | date | machine\_name | utilization | | --- | --- | --- | | 01-10-2022 | machine\_a | 10 | | 01-10-2022 | machine\_b | 5 | | 01-10-2022 | machine\_c | 50 | | 02-10-2022 | machine\_a | 15 | | 02-10-2022 | machine\_b | 40 | | 02-10-2022 | machine\_c | 14 | | 03-10-2022 | machine\_a | 1 | | 03-10-2022 | machine\_b | 5 | | 03-10-2022 | machine\_c | 30 | Here, I need to fetch the list of machines whose average utilization of a machine is less-than(\<) 10 for last 3 days. It would be great if you could possibly guide me to create a visualization with this requirement. Expected formula: min = 0 max = 10 range(average(utilization), min, max) ---

**Author:** ![weltenwort](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/weltenwort/32/53885_2.png) [@weltenwort](https://discuss.elastic.co/u/weltenwort)\ **Post date:** [October 6, 2022, 12:36pm UTC](https://discuss.elastic.co/t/kibana-visualization-need-a-solution-to-get-range-average-utilization-min-max/315955/2 "2022-10-06T12:36:11Z")

Hi @Lakshmi_Narayana_Red, I can't see a way to directly achieve that. The closest I could come is this lens table visualization: ![image](https://us1.discourse-cdn.com/elastic/original/3X/4/3/4311f8c5ef2f19934e99ec0d87033aa6895ebb64.png) But maybe someone else in community knows of a solution? ---

**Author:** ![Lakshmi\_Narayana\_Red](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lakshmi_narayana_red/32/111740_2.png) [@Lakshmi\_Narayana\_Red](https://discuss.elastic.co/u/Lakshmi_Narayana_Red)\ **Post date:** [October 6, 2022, 12:50pm UTC](https://discuss.elastic.co/t/kibana-visualization-need-a-solution-to-get-range-average-utilization-min-max/315955/3 "2022-10-06T12:50:36Z")

Thank you for your answer @weltenwort ! I aware of this way of getting the average, but I need hosts whose average utilization is less-than 10. ---

**Author:** ![weltenwort](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/weltenwort/32/53885_2.png) [@weltenwort](https://discuss.elastic.co/u/weltenwort)\ **Post date:** [October 6, 2022, 2:00pm UTC](https://discuss.elastic.co/t/kibana-visualization-need-a-solution-to-get-range-average-utilization-min-max/315955/4 "2022-10-06T14:00:34Z")

I can think of a query involving a `bucket_select` pipeline aggregation after a `terms` agg on the hostname field, which would return that information via the search API, but I don't know of a way to get the table visualization to perform such a query. Maybe you can use the "vega" visualization type as an escape hatch? ---

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [November 3, 2022, 2:01pm UTC](https://discuss.elastic.co/t/kibana-visualization-need-a-solution-to-get-range-average-utilization-min-max/315955/5 "2022-11-03T14:01:27Z")

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