Histograms

How to view task metrics in the Databand application.

Histogram overview

Let's check out the data shown in the standard histogram view.

A histogram is a visual representation of the data distribution in a specific column within a data target (such as a Dataframe or SQL table).

The horizontal axis shows a scale with equal bins between the minimum and maximum values. All data points within a column are distributed between these bins on the horizontal scale. The labels on the horizontal axis denote a range of values from the available minimum to the maximum value.

The vertical axis shows a scale with a count of values fitting each bin.

The histogram view also provides the following data profiling stats:

  • Minimum and maximum values
  • Total count of all analyzed values
  • The mean value
  • Standard deviation value
  • Distinct values count
  • Total count of all not Null values
  • Total count of all Null values
  • 25, 50, and 70 percentile ranks

For histograms with categorical data, you can also change the default sorting by frequency to sorting by alphabet.

Histograms Visualization

Example histogram showing the data distribution for a column named "AvgVolume"Example histogram showing the data distribution for a column named "AvgVolume"

Example histogram showing the data distribution for a column named "AvgVolume"

You can also visualize specific Histogram values via Task Metrics screens

Example chart showing the trend of distinct counts in a date column across pipeline runsExample chart showing the trend of distinct counts in a date column across pipeline runs

Example chart showing the trend of distinct counts in a date column across pipeline runs

To View Task Histograms

  1. In the Databand UI, open a pipeline run.
  2. From the pipeline, select a task that you want to preview.
  3. To view all histograms available for the selected task, perform one of the following steps:
  • Click the Histograms button on a top panel.
  • From the Inputs or Outputs section, select a dataset that you want to preview, and then click the Histograms icon.

What’s Next
Did this page help you?