Skip to main content

Celonis Product Documentation

Waterfall Chart
Introduction to Waterfall Chart

Use the "Waterfall Chart" component to display the cumulative effect of values.

41193289.png
Configuring a Waterfall Chart
Horizontal Waterfall Chart
41193289.png
- id: waterfallChartHorizontal
  type: waterfall
  settings:
    name: Horizontal Waterfall Chart # enter title here
    orientation: horizontal 
    kpis:
      - kpi: GEN_Quota # required, add the id of a KPI here
        color: BLACK # possible color options can be found below
        subparts: # optional, define sub-level KPIs
          - kpi: GEN_Total_Rev_FY
            color: BLUE_40
          - kpi: GEN_pipe_to_be_closed
            color: GRAY_20
            subparts:
              - kpi: GEN_expected_closing_FY
                color: BLUE_20
              - kpi: GEN_ACV_Gap
                color: RED_30

Vertical Waterfall Chart
41193290.png
- id: waterfallChartVertical
  type: waterfall
  settings:
        name: Vertical Waterfall Chart
        orientation: vertical
        kpis:
      - kpi: GEN_Quota # required, add the id of a KPI here
      - kpi: GEN_Total_Rev_FY_MINUS
        color: BLUE_40 # optional, possible color options can be found below
      - kpi: GEN_pipe_to_be_closed_MINUS
        color: GRAY_20
        subparts: # optional, define sub-level KPIs
          - kpi: GEN_expected_closing_FY_MINUS
            color: BLUE_20
          - kpi: GEN_ACV_Gap_MINUS
            color: RED_30

Position Lines

Position lines can be defined with a constant value or with a KPI.

id: waterfallChartVertical
type: waterfall
settings:
  name: Horizontal Waterfall Chart
  orientation: horizontal
  positionLines:
    - value: 20
      color: RED_10
      style: solid
      label: true
      title: Q1 Target
    - kpi: GEN_Quota
      color: RED_10
      style: solid
      label: true
      title: FY Target
  kpis:
    - kpi: GEN_Quota
      color: GRAY_60
      subparts:
        - kpi: GEN_Total_Rev_FY
          color: BLUE_20
        - kpi: GEN_expected_closing_FY
          color: BLUE_40
        - kpi: GEN_ACV_Gap
          color: BLUE_70
knowledgeModelKey: SIMPLE_CHARTS

Color Options

Possible color enum values are:

  • <HUE>_10, <HUE>_20, <HUE>_30, <HUE>_40, <HUE>_50 where <HUE> can be one of the following: BLUE, RED, GREEN, PURPLE, PINK

  • WHITE, GRAY_10, GRAY_20, GRAY_30, BLACK

Are you interested in using a waterfall chart? Write us here: Link