== Building Bar Charts

One of the exciting aspects of aggregations are how easily they are converted into charts and graphs.((("bar charts, building from aggregations", id="ix_barcharts", range="startofrange")))((("aggregations", "building bar charts from"))) In this chapter, we are focusing on various analytics that we can wring out of our example dataset. We will also demonstrate the types of charts aggregations can power.

The ++histogram++ bucket is particularly useful.((("buckets", "histogram")))((("histogram bucket")))((("histograms"))) Histograms are essentially bar charts, and if you've ever built a report or analytics dashboard, you undoubtedly had a few bar charts in it. The histogram works by specifying an interval. If we were histogramming sale prices, you might specify an interval of 20,000. This would create a new bucket every $20,000. Documents are then sorted into buckets.

For our dashboard, we want to know how many cars sold in each price range. We would also like to know the total revenue generated by that price bracket. This is calculated by summing the price of each car sold in that interval.

To do this, we use a histogram and a nested sum metric:

[source,js]

GET /cars/transactions/_search?search_type=count { "aggs":{ "price":{ "histogram":{ <1> "field": "price", "interval": 20000 }, "aggs":{ "revenue": { "sum": { <2> "field" : "price" } } } } }

}

// SENSE: 300_Aggregations/30_histogram.json

<1> The histogram bucket requires two parameters: a numeric field, and an interval that defines the bucket size. // Mention use of "size" to get back just the top result?

<2> A sum metric is nested inside each price range, which will show us the total revenue for that bracket

As you can see, our query is built around the price aggregation, which contains a histogram bucket. This bucket requires a numeric field to calculate buckets on, and an interval size. The interval defines how "wide" each bucket is. An interval of 20000 means we will have the ranges [0-19999, 20000-39999, ...].

Next, we define a nested metric inside the histogram. This is a sum metric, which will sum up the price field from each document landing in that price range. This gives us the revenue for each price range, so we can see if our business makes more money from commodity or luxury cars.

And here is the response:

[source,js]

{ ... "aggregations": { "price": { "buckets": [ { "key": 0, "doc_count": 3, "revenue": { "value": 37000 } }, { "key": 20000, "doc_count": 4, "revenue": { "value": 95000 } }, { "key": 80000, "doc_count": 1, "revenue": { "value": 80000 } } ] } }

}

The response is fairly self-explanatory, but it should be noted that the histogram keys correspond to the lower boundary of the interval. The key 0 means 0-19,999, the key 20000 means 20,000-39,999, and so forth.

[NOTE]

You'll notice that empty intervals, such as $40,000-60,000, is missing in the response. The histogram bucket omits these by default, since it could lead to the unintended generation of potentially enormous output.

We'll discuss how to include empty buckets in the next section, <<_returning_empty_buckets>>.

Graphically, you could represent the preceding data in the histogram shown in <>.

[[barcharts-histo1]] .Sales and Revenue per price bracket image::images/elas_28in01.png["Sales and Revenue per price bracket"]

Of course, you can build bar charts with any aggregation that emits categories and statistics, not just the histogram bucket. Let's build a bar chart of popular makes, and their average price, and then calculate the standard error to add error bars on our chart. This will use the terms bucket and an extended_stats ((("extended_stats metric")))metric:

[source,js]

GET /cars/transactions/_search?search_type=count { "aggs": { "makes": { "terms": { "field": "make", "size": 10 }, "aggs": { "stats": { "extended_stats": { "field": "price" } } } } }

}

This will return a list of makes (sorted by popularity) and a variety of statistics about each. In particular, we are interested in stats.avg, stats.count, and stats.std_deviation. Using((("standard error, calculating"))) this information, we can calculate the standard error:

................................ std_err = std_deviation / count ................................

This will allow us to build a chart like <>.

[[barcharts-bar1]] .Average price of all makes, with error bars image::images/elas_28in02.png["Average price of all makes, with error bars"]

((("bar charts, building from aggregations", range="endofrange", startref="ix_barcharts")))