Histogram

Overview

This chart consists of a series of upright rectangles whose area is proportional to the frequency of the variable. It looks similar to a bar graph but uses only one variable. The column widths are often equal but might vary reflecting the frequency density of the variable instead of the simple frequency.

What data do I need for this widget?

The option to create this chart will be enabled when your query contains at least one column that is not a JSON type.

Creating a histogram

1. Go to Data Search and open the required table.

2. Perform the required operations to get the data you want to use in the chart.

3. Click the gear icon on the toolbar and select Charts → Plots → Histogram.

4. Click and drag the column headers to the corresponding fields.

   Required field	Data type
   Values	Any type but json

   You can drag more than one column to the Values field and each of them will be represented as a separate histogram in the same window.

5. The histogram is displayed.
   
   

Working with histograms

You can use the following options to visualize different aspects of your histogram:

• Click and drag on the diagram to select a range and see the information of the rows contained in it.
  • Click the Apply filters to table button that appears at the bottom to create a filter in the table with the values contained within the range.
  • Click outside the range on the diagram to remove the selection.
• If your data is updated in realtime, the realtime toggle will appear at the top left. Activate it to update the chart with the new incoming data or deactivate it to keep the latest available data up to that moment.
• In case your query groups data, click by period to show the results of the latest available period.
  • Press the left and right directional keys to move back and forth in time through the different periods.
• Click the drop-down and select an argument to weight all the histograms in the window. The bars will be colored according to the argument selected.

Click on the button at the top right of the diagram to export the content as a CSV file.

Query example

You can recreate the example shown in the picture above with the data from the following query and mapping the fields as follows:

from demo.ecommerce.data

In case you want another example with the data grouped and more than one argument to add, here is another query to create it:

from demo.ecommerce.data
  group every 1m by bytesTransferred, timeTaken, statusCode
  every 1m