Visualize Numeric Value

[ChrisChua]

Hi,

I am new to ELK, this is my sample data : indent preformatted text by 4 spaces

{
	"Defect Count": {
		"Total": 0,
		"Test Category": "KitchenTest_AIX"
	},
	"Git Branch": "ivt_17.4",
	"Pass Rates": [
		{
			"Test Count": 119,
			"Error Count": 27,
			"Failure Count": 0,
			"Test Category": "KitchenTest_AIX",
			"Test Phase": "BVT",
			"Pass Rate": 0.773
		}
	],
	"Build Timestamp": "2017-10-24 06:32:00.0",
	"Build Version": 172,
	"Sprint": "17.4",
	"Build Name": "bvt.ivt_17.4.20171024-0232.172"
}

and this is my mapping:

{
      "mappings": {
        "statistic": {
          "properties": {
            "Build Timestamp": { 
              "type": "date",
              "format": "yyyy-MM-dd HH:mm:ss.0"
            },
            "Defect Count": {
              "type": "nested", 
              "properties": {
                "Test Category": { "type": "string"  },
                "Total": { "type": "float"  }
              }
            },
            "Pass Rates": {
              "type": "nested", 
              "properties": {
                "Error Count": { "type": "float"  },
                "Failure Count": { "type": "float"  },
                "Pass Rate": { "type": "float"  },
                "Test Category": { "type": "string"  },
                "Test Count": { "type": "float"  },
                "Test Phase": { "type": "string"  }
              }
            }
          }
        }
      }
}

and this is the result in elasticsearch

Now I try to create a visualization like this:

Barchart=Test Count
Linechart=Pass Rate

and this is what I tried but it doesn't work

Sorry for my poor English, any help is appreciated

[weltenwort (Felix Stürmer)]

Hi @ChrisChua,

the only thing that stands out is the use of spaces in the field names, which is generally not recommended. Beyond that, it could be helpful to take a look at the response returned by elasticsearch for the visualization. You can inspect that by expanding the "spy" panel with the small arrow beneath the visualization.