# Not able to locate fields in Kibana

**URL:** <https://discuss.elastic.co/t/not-able-to-locate-fields-in-kibana/267502>\
**Category:** Kibana\
**Created:** [March 17, 2021, 12:35pm UTC](https://discuss.elastic.co/t/not-able-to-locate-fields-in-kibana/267502 "2021-03-17T12:35:39Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Robert\_Nelson](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/robert_nelson/32/85685_2.png) [@Robert\_Nelson](https://discuss.elastic.co/u/Robert_Nelson)\
**Post date:** [March 17, 2021, 12:35pm UTC](https://discuss.elastic.co/t/not-able-to-locate-fields-in-kibana/267502/1 "2021-03-17T12:35:39Z")

</div>

Hello all  
I am new to ELK. I have a trial account on [Elastic.CO](http://Elastic.CO).  
I wish to create a velocity chart for the recent sprints in Kibana. Please note that my data is not based on time-series.

I am not able to locate the fields I passed in Elasticsearch in Kibana Vsualisation.  
Here is my approach

1. Insert data into ElasticSearch from Python

```auto
es2 = ElasticSearch() ||---> This step works.
list_sprint = ["a","b","c","d","e","f"]
list_vel = ["1","2","3","4","5","6"]
db_name = "agile_kpi"
table_name = "aeg"

for i in range(len(list_sprint)):
		j = i+1
		body = {
				 "sprint":list_sprint[i]
				,"velocity":list_vel[i]
				,"team":table_name
				,"graph_type":"vel_hist"
				,"id":j
				}
		res = es2.index(index=db_name, doc_type=table_name, id=j, body=vel_hist)

```

1. I am able to see this in Kibana Discover  
JSON for 1 row (or document) is given below

```auto
{
  "_index": "agile_kpi",
  "_type": "aeg",
  "_id": "1",
  "_version": 1,
  "_score": 0,
  "_source": {
    "sprint": "a",
    "velocity": "1",
    "team": "aeg",
    "id": 1
  }
}

```

1. When I go to visualisation and choose Vertical chart, for Y-Axis, I can only see ID.  
I should be able to choose velocity for Y-Axis and Sprint for X-axis.

Please help.

---

<div class="post-metadata">

**Author:** ![Aaron\_Caldwell](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron_caldwell/32/45755_2.png) [@Aaron\_Caldwell](https://discuss.elastic.co/u/Aaron_Caldwell)\
**Post date:** [March 17, 2021, 4:43pm UTC](https://discuss.elastic.co/t/not-able-to-locate-fields-in-kibana/267502/2 "2021-03-17T16:43:13Z")

</div>

Hello,

It looks like `velocity` is being inserted as text. Try switching it to an array of numbers and the default mapping should insert it as numbers. Alternatively you could explicitly define the mapping for the index so that velocity is always captured as a number.

Hope that helps!

Regards,  
Aaron

---

<div class="post-metadata">

**Author:** ![Robert\_Nelson](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/robert_nelson/32/85685_2.png) [@Robert\_Nelson](https://discuss.elastic.co/u/Robert_Nelson)\
**Post date:** [March 18, 2021, 4:46am UTC](https://discuss.elastic.co/t/not-able-to-locate-fields-in-kibana/267502/3 "2021-03-18T04:46:12Z")

</div>

Hello Aaron  
Thanks for responding. Should I insert the array of sprint names ["a","b"....] and velocities [1,2,3,...] ?

---

<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:** [April 15, 2021, 4:46am UTC](https://discuss.elastic.co/t/not-able-to-locate-fields-in-kibana/267502/4 "2021-04-15T04:46:32Z")

</div>

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