Visualize Numeric Value

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

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.

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