# Waterfall chart

{% hint style="info" %}
*Check out the walk-through on properties of the Waterfall chart.*
{% endhint %}

<figure><img src="https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FcQsszhLqHiL1GpPjSENz%2FWaterfall%20chart.gif?alt=media&#x26;token=669b1f8c-8ae1-4e4f-bbc4-01e13005bb78" alt=""><figcaption></figcaption></figure>

A Waterfall Chart is a form of data visualization that helps in understanding the cumulative effect of sequentially introduced positive or negative values. The Waterfall Chart is used to show how an initial value is increased and decreased by a series of intermediate values, leading to a final value.

**Best Situations to Use Waterflow chart:**

To show incremental changes in the values over time

<figure><img src="https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FYw0PyVHMmGh5if5hTt5A%2Fimage.png?alt=media&#x26;token=ec289d33-099c-4dae-a22c-b1a47ab4a342" alt=""><figcaption></figcaption></figure>

## **Properties** <a href="#properties" id="properties"></a>

### **General Settings**

* **Order**: Select a sequence for displaying information.

  * None
  * Ascending
  * Descending
  * Manual Sort: The user needs to sort the dimensions by using the indicator signs manually. By selecting an order (ascending or descending), the user needs to configure the following fields:
    * **Order By**- Select a value option from the drop-down menu to order the sequence of the data.
    * ***Limit***- Set a number to display the requested data by this limit.
  * **Exclude Global Filter**: The view gets excluded from the Global Filter condition by putting a checkmark in the box.
  * **Enable Base Zero**: Base value gets presented from Zero by providing a checkmark in the box.
  * ***Show Legend***: By enabling this option the Legend gets added to the chart.

  &#x20;    ![](https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2Fm2d5ALj97dAaRfDg1xcl%2Fimage.png?alt=media\&token=67b4bc9e-1226-4642-bd58-454c13549761)**​**

*Please Note: At present the supported **Legend Style** is **Floating** only*.

### **View Filter**

* **Filter**: Select a filter condition using the drop-down menu.

### **Column Colors**&#x20;

Select a color from the given choices: ***Positive, Negative, and Total.​***![](https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FjrsNMDktCHnIFvPGhUZE%2Fimage.png?alt=media\&token=9df8e5be-4141-480a-ab5b-615d0e829d87)***​***

### **Category Axis**

* **Title**: Provide a title for the axis
* **Axis Label**: Enable the Category Axis label by putting a checkmark in the box.
* **Label Angle**: Select a display angle for the axis label.

​![](https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FBPFRzX7FuHXL6mckM842%2Fimage.png?alt=media\&token=8dbdd1a6-095f-4054-949f-6ccf9cb7f1cc)​

### **Primary Value Axis**

* **Title**: Provide a title for the Primary Value Axis.
* **Axis Label**: Enable the Primary Value Axis label by putting a checkmark in the box.
* **Format Type**: Select a desired format type from the drop-down menu (the provided options for this field are: None, Auto, Percent, Thousand, Lacs, Crore, Million).
* **Currency Type**: Select a currency symbol to be displayed in the view (the provided options for this field are: None, Euro, Rupees, Pound, USD, Yen, Cent).
* **Precision**: Set the after-decimal value (It displays up to 5 precision).

&#x20;   ​![](https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2F18LPgvMW2UaNyHPY4NNY%2Fimage.png?alt=media\&token=19921bfd-9135-4a22-8487-c745e2fbb30e)

### **Insights**

* **Text:** *Provide any information regarding the chart. If any digit or character is required to be highlighted, put it inside two asterisks. (E.g., \*70%\* or \*skills\*).*
* **Text align:** There are three alignments to align the text.
  * Left
  * Right
  * Centre
* **Position:** There are two options to position the text.

  * Bottom
  * Right

  ​![](https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2F4CA34Cve6x3d6OorzGDw%2Fimage.png?alt=media\&token=da1e5904-1868-448a-bfb1-ffea42bb04fe)​​

The modified chart view after the chart properties gets applied.

<figure><img src="https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FzviBqhgEeJQ1UrNYq2gz%2Fimage.png?alt=media&#x26;token=147bfb66-46a2-49a6-afd2-63d0c8994f4f" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
*<mark style="color:green;">Please Note</mark><mark style="color:green;">:</mark> When the selected Format Type is **Percentage**, you don’t get the **Currency Type** field.*
{% endhint %}

**Series Properties**&#x20;

* Click the ***Series Properties*** provided next to the measure name.

&#x20;      ![](https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FQne8ZDqagfgCZQ5ANPrE%2Fimage.png?alt=media\&token=aa636b88-2e2b-4cde-894f-451cc5e25db7)

* A new window opens.
* Configure the required details:
  * **Aggregation**-select an aggregation using the drop-down menu (By default, it displays the second aggregation type which is **Sum.**)
  * **Display Name**- provide a name to be displayed in the legend.
* Click the ***APPLY*** option.

![](https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FR6YU5ndqAx6O7GU286Es%2Fimage.png?alt=media\&token=c14e7301-7820-4435-9299-cea2d833c213)

* The configured ***Series Properties*** gets applied to the chart.​


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.bdb.ai/self-service-visualization/chart-gallery/waterfall-chart.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
