# How to extract data from a field and get the max values?

**URL:** <https://discuss.elastic.co/t/how-to-extract-data-from-a-field-and-get-the-max-values/253491>\
**Category:** Kibana\
**Created:** [October 27, 2020, 8:44pm UTC](https://discuss.elastic.co/t/how-to-extract-data-from-a-field-and-get-the-max-values/253491 "2020-10-27T20:44:16Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![AdrianH](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/adrianh/32/77955_2.png) [@AdrianH](https://discuss.elastic.co/u/AdrianH)\
**Post date:** [October 27, 2020, 8:44pm UTC](https://discuss.elastic.co/t/how-to-extract-data-from-a-field-and-get-the-max-values/253491/1 "2020-10-27T20:44:16Z")

</div>

Hi,

I'm new to Kibana (using version 6.4.2) and am trying to extract some values out of a field. This would require parsing the field to extract 3 numbers.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/7/27e3d58cca5121dc3342b88fd73ebe476b5c077e.png)

I could export this data out to a CSV, but seems that if I try and get more than 3 wks of data, I get a timeout error. Also, when I press the Share option, I don't see a CSV Reports option that is indicated in [this](https://reelyactive.github.io/diy/kibana-export-data-csv-file/) tutorial:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/b/e/be028d20b343cc1339335d76cbdb76b68e0f280e.png)

Is there a way that I can pull out the numbers with more log entries?

Thanks.

A

---

<div class="post-metadata">

**Author:** ![myasonik](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/myasonik/32/62369_2.png) [@myasonik](https://discuss.elastic.co/u/myasonik)\
**Post date:** [October 29, 2020, 9:46pm UTC](https://discuss.elastic.co/t/how-to-extract-data-from-a-field-and-get-the-max-values/253491/2 "2020-10-29T21:46:43Z")

</div>

You may not see the CSV export option if you are using the open source license. CSV exporting is available only in the free Basic license and higher.

If you are just trying to extract the numbers and find a value, you could all of that inside of Kibana using a scripted field to extract the value and a metric visualization.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [November 26, 2020, 9:46pm UTC](https://discuss.elastic.co/t/how-to-extract-data-from-a-field-and-get-the-max-values/253491/3 "2020-11-26T21:46:44Z")

</div>

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