date histogram

This block is part of the aggregation group and was last modified in core v13.0.3.

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.

date histogram v13.0.4 Updated v13.0.3

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

In pins 7
  • 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
Out pins 1
  • aggregation
    aggregation

A typical wiring for date histogram: value feeds the interval pin; the aggregation out pin feeds aggregation.

Studio canvas example for the date histogram block: typical wiring for date histogram.

Version history

Introduced in v13.0.4.

Last modified in v13.0.3.

v9.3.2 This block or one of its pins was updated in v9.3.2, click here to see the release notes.
Back to aggregation Return to the main group to view all sub-groups Back to aggregation Return to the group to view all blocks within this group