Date gap analyzer

Analyze the periodic gaps between FROM and TO dates.

  • Date gap count

    Parameterized by value
  • Total date gap count

    Not parameterized
  • From column

    InputColumn<Date> Required
  • To column

    InputColumn<Date> Required
  • Group column

    Optional column to group timelines by, if the table contains multiple timelines

    InputColumn<String> Optional
  • Count intersecting from and to dates as overlaps

    Boolean Optional
  • Fault tolerant switch from/to dates

    Turn on/off automatic switching of FROM and TO dates, if FROM has a higher value than TO.

    boolean Optional