Not able to locate fields in Kibana

[Robert_Nelson]

Hello all
I am new to ELK. I have a trial account on 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

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)

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

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

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

[Aaron_Caldwell]

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

[Robert_Nelson]

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