# Need a little help with kibana visualization

**URL:** <https://discuss.elastic.co/t/need-a-little-help-with-kibana-visualization/194872>\
**Category:** Kibana\
**Created:** [August 12, 2019, 3:10pm UTC](https://discuss.elastic.co/t/need-a-little-help-with-kibana-visualization/194872 "2019-08-12T15:10:12Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mhare](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mhare/32/52213_2.png) [@mhare](https://discuss.elastic.co/u/mhare)\
**Post date:** [August 12, 2019, 3:10pm UTC](https://discuss.elastic.co/t/need-a-little-help-with-kibana-visualization/194872/1 "2019-08-12T15:10:12Z")

</div>

I am using 7.3 of logstash, elasticsearch and kibana on a Windows PC

I am ingesting csv from 5 files, which seems to be working.  
My Filter  
filter {  
csv {  
columns =\> [  
"timestamp","uptime","ramused","memused","memfree","memshrd","membuff","memcached","usr","sys","nic","idle","io","irq","sirq","time","nvmramreboot","sdinit","sdcurrent","sdmax","fwversion","ipaddress","devicetype"  
]  
convert =\> {  
"memused" =\> "integer"  
"memfree" =\> "integer"  
"membuff" =\> "integer"  
"memshrd" =\> "integer"  
"memcached" =\> "integer"  
"sdcurrent" =\> "integer"  
"sdinit" =\> "integer"  
"ramused" =\> "integer"  
"idle" =\> "float"  
"usr" =\> "float"  
"io" =\> "float"  
"nic" =\> "float"  
}  
separator =\> ","  
}  
}

I can go into Dev Tools, issues a

GET /memleak/\_search  
{  
"query": {  
"match\_all": {}  
}  
}

and I get a reasonable output meaning the values from the csv I've converted to integer and float are being displayed as such in the output

I can discover the files and once again get a reasonable output  
But I cannot visualize anything beyond a straight count of ingested objects

I converted things like memfree to an integer so I could get metrics like max memfree, or min memfree or average memfree

I created a new visualizer for a Metric. I changed the metric aggregation to Average but Field does not show me any of my integer fields. It says "The index pattern memleak does not contain any of the following compatible field types: number"

I thought that was why I converted the fields to integer, but I guess not.  
So, how do I get these to be a 'number' so I can do cool stuff with them?

Thanks!

---

<div class="post-metadata">

**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\
**Post date:** [August 13, 2019, 11:07pm UTC](https://discuss.elastic.co/t/need-a-little-help-with-kibana-visualization/194872/2 "2019-08-13T23:07:32Z")

</div>

Could you provide the result of running the following?

```auto
GET /memleak/_mapping

```

---

<div class="post-metadata">

**Author:** ![mhare](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mhare/32/52213_2.png) [@mhare](https://discuss.elastic.co/u/mhare)\
**Post date:** [August 15, 2019, 6:44pm UTC](https://discuss.elastic.co/t/need-a-little-help-with-kibana-visualization/194872/3 "2019-08-15T18:44:44Z")

</div>

Thank you for responding. It's working now, but I cannot honestly tell you why.

---

<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:** [September 12, 2019, 6:44pm UTC](https://discuss.elastic.co/t/need-a-little-help-with-kibana-visualization/194872/4 "2019-09-12T18:44:46Z")

</div>

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