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"
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 runs
To View Task Histograms
- In the Databand UI, open a pipeline run.
- From the pipeline, select a task that you want to preview.
- 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.
Updated 8 months ago