---
title: "date histogram · RUAL Documentation"
description: "Groups data based on a date histogram, allowing analysis over specified intervals."
canonical: https://docs.rual.nl/block-types/aggregation/aggregation_type_date_histogram_bp_field
language: en
---

# date histogram

This block is part of the [`aggregation`](https://docs.rual.nl/block-types/aggregation) group and was last modified in core [`v13.0.3`](https://docs.rual.nl/core-versions/130003).

### Field Selection Required

This block relies on a field that you select to perform its data actions. You must manually select the field you want to use in your flow using the field selector modal. To access the modal, click the white button on the block.

Groups data based on a date histogram, allowing analysis over specified intervals.

- Interval required `value` minute | hour | day | week | month | year

- Format `v13.0.4` `value` The format to convert the key_as_string to an formatted date string with.

- Missing `value` Replace missing values with (default skip)

- minimum `number` Minimum documents required to use it (default: none)

- order key `v9.3.2` `value` The sub-aggregation name to order on or `_key` to sort on the current field.

Default `_count`

- order asc `v9.3.2` `condition` Order results in an ascending manner.

Default `false`

- Options `object`

- aggregation `aggregation`

A typical wiring for [date histogram](https://docs.rual.nl/block-types/aggregation/aggregation_type_date_histogram_bp_field): [value](https://docs.rual.nl/block-types/value/value_default) feeds the `interval` pin; the `aggregation` out pin feeds [aggregation](https://docs.rual.nl/block-types/query/query_aggregation).

![Studio canvas example for the date histogram block: typical wiring for date histogram.](https://docs.rual.nl/canvas-examples/aggregation_type_date_histogram_bp_field.png)

### Version history

Introduced in [`v13.0.4`](https://docs.rual.nl/core-versions/130004).

Last modified in [`v13.0.3`](https://docs.rual.nl/core-versions/130003).