Visualization in Kibana - Y axis configured dynamically

(Sanjay Saatyaki) #1

Hi, I added 3 values similar to the json i have attached below. When i am creating a visualization with sub-buckets I am encountering issues in the y axis. The scale of the y axis is dynamically as the below snap shot
Sample Json
{
"_index": "emp_db",
"_type": "emp_profile",
"_id": "12345",
"_version": 1,
"_score": 0,
"_source": {
"name": "XXX",
"email": "XXX@yyy.com",
"dept": "RRRR/CCC",
"role": "Architect",
"projects": [
"abc",
"cdef"
],
"skills": [
{
"name": "Java",
"level": "Advanced"
},
{
"name": "DevOps",
"level": "Advanced"
},
{
"name": "Jenkins",
"level": "Advanced"
},
{
"name": "Docker",
"level": "Beginer"
}
]
}
}
In the other 2 json the value of the java in skills is Advanced. But while creating the visualization it is repesenting that java has values like beginner, and intermediate.

Snapshot is attached below:

Here the value of the Y axis is supposed to be 3.Since i have only 3 values. But it changed dynamically as 6 when add sub-bucket. How can i resolve this??

The Y - axis is set to count and X axis - skill name, skill level